I write about SQL Server…and occasionally something else.
-
Database Corruption Week 1 Solution Here is my solution for week one. The original database and details for this can be found here: http://stevestedman.com/2015/04/introducing-the-database-corruption-challenge-dbcc-week-1-challenge/
-
New Lab Environment 2015
I have recently been looking at solution for hardware for a new home lab. The primary need was a lower power solution, with plenty of ram and the ability to run hyper-v. The solution I have chosen is a small form…
-
SQLBits XIV – 4 – 7 Mar 2015
So who is going to be at SQLBits XIV this coming week? Add me if you are about @JonGurgul The ExCeL, Royal Victoria Dock, 1 Western Gateway, London E16 1XL https://sqlbits.com/
-
Help, I have lost a SQL data file and I have no backup
This week I stumbled across a post on the forum that was quite interesting in terms of recovery in dire situations. The op basically had lost a SQL data file and was in a situation where they had no backups.…
-
SQL Index dm_db_index_xxx_stats
There are 3 dm_db_index_xxx_stats objects that can be used to check and investigate index information. sys.dm_db_index_usage_stats can be used to see how beneficial the index is, and its related maintenance cost. Note that this information is reset upon instance restart.…
-
Surface Pro 3
Surface Pro 3 My first impression of the Surface Pro 3 was that Microsoft had produced a tablet/laptop that was really tempting. The choice of which model to buy is obviously dependent on how you want to use it, but…
-
Find SQL Server Instances
Any environment will kick up the odd surprise with extra servers you did not know about (suddenly appearing), which is why I always like to have a look around the environment every so often to see what is there. So…
-
A simple what is running script aka a modern sp_who2
There is a great deal of information that can be gathered to show what is currently running on SQL Server, but sometimes simple and brief is best. So here is a quick overview gathering scripts with limited bells and whistles.…
-
T-SQL: Sequential Numbering
Introduction It is as easy as 1, 2, 3. A generic numerical sequence which is incremented from a known value. In this article we will look at the options that are available to create sequences which have primarily used identity,…
-
Check status of SQL Jobs
Finding out the status of SQL Jobs is a simple task which can be accomplished via the GUI or in code using EXEC msdb.dbo.sp_help_job. However one issue that is encountered is that the results from this procedure can not easily…
Join 900+ subscribers
Stay in the loop with everything you need to know.