| A community of more than 1,600,000 database professionals and growing |
| | | Coming Attacks The pieces by Bruce Schneier related to security are fascinating. One of his latest posts looks at potential coming attacks to our Internet infrastructure, which could potentially take down parts of the worldwide network. Whether you think this is a valid concern or not, it bears thinking through the issue a bit. If something did happen, your organization could be affected. Imagine what would happen to your production sites if they, or their clients, couldn't resolve a DNS address. Or if there was a DDOS against your domain, perhaps just as a test by attackers to see where you might be vulnerable. What would be your response? For most of us, there isn't much we could do, but I'm sure your management would want some answer, so do you have a way to respond? Would you worry if there were a targeted attack against your database servers using SQL Injection, cross site scripting, or some other technique? What about your development efforts? So many people have started to use services like Slack, Trello, cloud hosting of repositories and more. Could you continue to develop software if the Internet went down for your company? I've certainly thought about this for my work, and some things would be off-line, and I could have potential scheduling issues. However, I don't work on mission critical systems, so I could work on something off-line and push production schedules by a day or two. Certainly control systems, embedded systems, and more are vulnerable to these types of attacks. If they depend on data, could they be attacked with fake or compromised data? I hope that some of these companies that have critical system, get serious about security in the event that an attack is targeted at their infrastructure. I don't know if that will happen, and I really hope not. The Internet is a wonderful, collaborative resource, and will be for a long time if the criminals don't fundamentally ruin our trust in it. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 2.6MB) podcast or subscribe to the feed at iTunes and Libsyn . The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | Could you deploy a high number of databases? Imagine working in a 70-strong IT team, with 91 applications and multiple complex databases. Now imagine deployment time. It's not fiction, it's fact. See how financial services company, FlexiGroup, has brought speed and precision to database deployments. Read their story. |
| | | | Find SQL in your database for free For example, want to rename one of your table columns but are not sure what stored procedures reference it? Using Redgate’s free SSMS add-in, SQL Search, you can search for the column name and find all the stored procedures that use it. Find out more and download now. |
| | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more. |
|
|
|
| | | | | Kenneth Fisher from SQLServerCentral.com Data types are an important part of how tables and variables work. Did you know that constants have databases too? More » |
| | Additional Articles from SimpleTalk The ALL, SOME and ANY predicates aren't much used in SQL Server, but they are there. You can use the Exists() predicate instead but the logic is more contorted and difficult to read at a glance. Set-oriented predicates can greatly simplify the answering of many real-life business questions, so it is worth getting familiar with them. Joe Celko explains. More » |
| | Press Release from SQLServerCentral.com A free day of training on Monday, October 24 in Seattle this year. Join MCMs, MVPs, and Friends of Redgate for a free day of training. More » |
| | Kenneth Fisher from SQLServerCentral Blogs A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following: Negative... More » |
| | The Database Avenger from SQLServerCentral Blogs This is the 4th post in the series named SQL Server and Continuous Integration. The first 3 posts covered the need... More » |
|
|
| | | Today's Question (by Steve Jones): What does this return? SELECT CEILING(-2.3) |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: CEILING(). We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | | S M from SQLServerCentral.com While facing a trouble dropping a Login account, use the below script:- Server principal 'xx\yy' has granted one or more permission(s). Revoke the permission(s) before dropping the server principal. (Microsoft SQL Server, Error: 15173). Run the above steps. More »
|
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Maximum number of CROSS APPLY functions - I can't find a maximum number for CROSS APPLY lines in a single query. I know this has to be... Starpoint Gemini 2 - [url=https://www.linkedin.com/pulse/gemini-2-review-oct-2016-report-scam-true-binary-lina-merchant]Gemini 2 Review[/url] it would happen - [url=https://www.squadup.com/events/gamehdq-chiefs-vs-steelers-2016-live-stream-sunday-night-football-week-4-time-100316] Chiefs vs Steelers Live Stream[/url] Backup Permissions and User - Hi all, Can I confirm on the following understanding q1) It doesn't matter which database a login/user is currently at as long... luminis skin serum Skincare Free Trial Where to Buy? - It keeps your skin drenched and hydrated for the length of the day. It restores the hurt skin cells and... In SQL 2014 SSISDB, how do I BACKUP an original SSIS Pkg, named PKG_A, residing in FOLDER_1 under SSISDB in the Integration Services Catalog - This will be for a contingency restore in the event the newly modified and deployed pkg w/ the same name,... Need to restore 700+ DBs without any data - Hey all, I have a bit of a situation and wondering if someone can help me. I have 700+ DBs... the ocmer c ir ejri cjen r eurner - [url=http://jaguarsvscolts.co/]Jaguars vs Colts[/url] [url=http://jaguarsvscolts.co/]Jaguars vs Colts Live[/url] [url=http://jaguarsvscolts.co/]Jaguars vs Colts Live Stream[/url] [url=http://texansvstitans.co/]Texans vs Titans[/url] [url=http://texansvstitans.co/]Texans vs Titans Live[/url] [url=http://texansvstitans.co/]Texans vs Titans Live Stream[/url] [url=http://brownsvs-redsk SQL Server license requirements - My query is whether SQL server license is required for the WEB server & for the application server ? Or is it... SPID blocking frequently - SPID blocking randomly & very frequently in OLTP database. This database is AOAG (Alwayson availability groups), since last two days transaction get... Get children of a parentID - Hello, I have a table with the following structure: MenuID(int) Menu(varchar) ParentID(int) How do get all children nodes of a given MenuID even... Hurricane Matthew might be in North Carolina - [url=https://www.squadup.com/events/snfitv-steelers-vs-chiefs-live-stream-nfl-gamecast-online-onair]Steelers vs Chiefs Live Streaming[/url] [url=https://www.youtube.com/watch?v=yuSTpErqMjc]Steelers vs Chiefs Live Streaming[/url] [url=https://www.squadup.com/events/watchsnfnbc-chiefs-vs-steelers-live-stream-online-nfl-2016-snf-football-week4-from-heinz-field]Chiefs vs Steelers Live Streaming[ get sum of max values - I have a table with dates date Sends Opens Clicks Bounces 9/1/2016 1 2 4 5 9/1/2016 1 2 4 5 9/16/2016 0 10 23 5 9/16/2016... Howto move Mobile Report to other Server? - Hi, we were playing around with SQL Server 2016 a bit. Mobile Reports look fine, we did about 15 useful on our... Trump Tax Records Obtained by The Times - [url=http://sydney.craigslist.com.au/res/5809056117.html]NRL Grand Final 2016 Live streaming[/url] Mike Pence Tells Wrongfully Convicted Man - [url=https://www.youtube.com/watch?v=t_qtfAnDWXc]Patriots vs Bills Live Streaming[/url] [url=https://www.youtube.com/watch?v=MparbovzddA]Jets vs Seahawks Live Streaming[/url] [url=https://www.youtube.com/watch?v=yCUndDskAEM]Texans vs Titans Live Streaming[/url] [url=https://www.youtube.com/watch?v=-ryJ2EMghmE]Redskins vs Browns Live Streaming[/url] [url=https://www.youtube.com/watch?v= How to extract a value from XML column in a SQL Table - Hi there I have a SQL table called dbo.AuditItem. This contains a column called [OldRow]. This column is in XML format I want... Modelling grain and fact table key - Hi, I'm new to datawarehousing and am really working through a lot of concepts with no guidance or mentor. I have... Need Help in finding data within range - Thanks for all support here. I have a table which has quantity,price ,item,date. I am trying to develop a stored procedure... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. | This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here. | This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
