All DBAs need to engage in a little project management to help make sure everything runs smoothly. In this extract from the book Tribal SQL, David Tate explains his system for managing workload, colleagues, and projects, and how not to be just "the guy who says no".
2014-02-24
3,072 reads
March 15, SQLServerCentral's Steve Jones and many others (including Kalen Delaney, Kevin Boles, and Karen Lopez) will be presenting at SQL Saturday Silicon Valley. This is a free, one-day learning event about SQL Server, Microsoft Business Intelligence, and Big Data. Register soon while spots are available.
2014-02-24
1,672 reads
A Hyper-V replica will provide a rapid disaster-recovery by simply replicating to a standby site a VM running at the primary site. Is it, therefore, ideal for running SQL Server in high-availability? Well, it depends on the type of HA you require, and whether you need the features that aren't supported.
2014-02-21
3,378 reads
SQL Saturday is coming to Vienna on March 6 with a full-day of technical training and networking, featuring international speakers. With over 20 sessions on SQL Server, the event is aimed at all those interested in SQL Server - from pros to beginners.
In 2014 the event is held for the first time in Austria, Vienna, organized by PASS Austria.
2014-02-21
1,646 reads
Learn how to create a SQL Server execution plan. This article explains the basics used in performance tuning, an important skill for DBA's and SQL developers alike.
2014-02-20
10,654 reads
SQL Server security related tasks can be divided into four main categories: physical security, operating system level security, SQL Server configuration and user management. Here is your SQL Server security checklist.
2014-02-20
4,963 reads
The SEQUENCE statement introduced in SQL Server 2012 brings the ANSI SQL 2003 standard method of generating IDs. This is a great relief to database professionals as it solves some problems what are awkward to solve with the IDENTITY property. Joe Celko explains the basics of using a SEQUENCE.
2014-02-19
5,839 reads
SQL Saturday is coming to New Haven, Connecticut on March 01, 2014. SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This is a free event, so register early to secure your place.
2014-02-18
1,325 reads
Recently we presented a procedure for uploading data to a Windows Azure SQL Database from an on-premise SQL Server instance. Today we will accomplish the same objective by employing a more traditional approach to data extraction, transformation, and loading (ETL) that relies on SQL Server Integration Services (SSIS).
2014-02-18
3,765 reads
Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.
2014-02-17 (first published: 2011-01-26)
14,582 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers