SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008
Apr 16, 2015
Looking for SQL Server 2014 SP 1... Hold Off a Bit Longer
Microsoft released service pack 1 for SQL Server 2014 on April 15, 2015. Why can't we download it though?
Jan 13, 2017
Identifying Logins with Default Database Connectivity Issues in SQL Server
You've a valid login and password. You've rights to the database you're trying to query. You've verified the sids (unique identifier for a SQL Server login and a database user) match. That's all that is needed to run a query on your database given you have no network issues between you and the database server right? Wrong. In this article Tim Ford looks at another way in which you or your customers may not be able to reach their data and provides a script for identifying those logins that may be involved.
Dec 30, 2016
How Old Are Your Backups?
Do you want a quick view into how old your backups are or if you're missing any backups on your SQL Server instances? Here is a query for determining just that.
Dec 29, 2016
Querying Secure Information from a Restored Master Database Backup
I was recently asked if it was possible to get security information from a restored copy of the SQL Server master database. This article touches on just how easy it is to get information about that and other things from a restored copy of master and without rights in the original master database.
Dec 23, 2016
SQL Server IO Analysis Part 1
The SQL Server Dynamic Management Objects provide a wealth of information about performance within the internal structures of Microsoft SQL Server. In this series Tim Ford will start with identifying the base Dynamic Management Function involved in collecting IO baselines. In subsequent articles in this series he'll expose collection, benchmarking, statistical analysis and reporting of the metadata collected for use in root cause analysis as well as in refuting misconceptions about performance issues rooting themselves in "poor storage performance rather than burdensome untuned queries.
Nov 14, 2016
Don't Panic: Busting a File Space Myth
Just because a data file is almost out of space doesn't mean it's going to endure an auto-grow event.
Nov 2, 2016
What Every Accidental DBA Needs to Know Now: SQL Server Agent Part 1 - Job Scheduling
Oct 26, 2016
Sending Results of DBCC CHECKDB SQL Agent Job Via Email
Sending the results of DBCC CHECKDB is not too difficult but there is a couple of things that, if you've not dealt with before, will serve as issues with successfully architecting a solution.
Oct 17, 2016
How to Set Up SQL Server Database Mail in One Easy Script
Database Mail in Microsoft SQL Server allows for messaging to occur between SQL Server and anyone with a valid email address. It can be daunting to set up through SQL Server Management Studio but by using the SQL Server Template in this article you'll find you can do so in just a few minutes.
Oct 3, 2016
What Every Accidental DBA Needs to Know Now: Basics of SQL Security
Congratulations you're now a DBA! What do you need to know about security for SQL Server? Read on and find out.
Sep 26, 2016
What Every Accidental DBA Needs to Know Now: SQL Server Configuration Manger
The SQL Server Configuration Manager is an critical but often overlooked application for proper SQL Server instance management and, well, "configuration". In Tim Ford's continuing series aimed at the Accidental Database Administrator he takes time to explain the basics of this tool, its use, and its features.
Sep 15, 2016
How to Restart Failed Log Shipping Quickly
Log shipping is a great tool for maintaining a redundant copy of your database to protect against site failures in a disaster recovery situation but what happens when it stops unexpectedly and you've an unknown number of transaction log backups to apply to get it going again? Tim has a script for you to identify the next transaction log backup to restore and kick-start the process.
Aug 31, 2016
What Every Accidental DBA Needs to Know Now: #2 Restores
Aug 7, 2016
What Every Accidental DBA Needs to Know Now: Backups
What are the most important things for an Accidental DBA to know in order to survive in their new career?
Jul 11, 2016
SQL Server 2014 SP2 Now Available
Fast on the heels of the release of SQL Server 2016 comes the latest service pack for SQL Server 2014 packed with over 20 improvements and cummulative hotfixes including SP1 CU7.
Apr 28, 2016
Security Options for Developers in Dev/Sandbox Environments
As a DBA is it possible to limit access to only the objects a user needs rights to without being a constant blocker for new development from your developers and engineering teams? It definitely is but there are options with their own benefits and risks.
Apr 26, 2016
Introduction to the Index Operational Statistics Dynamic Management Function
How do query operations translate to metadata inside two popular SQL Dynamic Management Objects?
Terms of Service
View Full Site
Copyright © 2017