Archives: February 2016
By Steve Bolton
…………Just as a good garage mechanic will fill his or her Craftsman with tools designed to fix specific problems, it is obviously wise for data miners to stockpile a wide range of algorithms, statistical tools, software packages and the like to deal with a wide variety… Read more
PowerShell – Backup Individual database and delete all it’s respective files by keeping a recent file
The requirement is to backup individual database and after successful backup the script should retain the most recent file and delete the rest from a directory for that specific database.
The below Powershell script is used to backup a specific database on a given directory
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null…
You need to be aware that you’re going to see differences when you’re working with Azure SQL Database when it comes to wait statistics. If you’re running a v12 Azure SQL Database (and if you’re not, go fix it), you can run a query against sys.dm_os_wait_stats. Here’s the output for… Read more
This Friday I will be holding a precon training session at the next SQL Saturday in Chicago called ‘SQL Server Infrastructure Tuning for Availability and Performance.’ Only a few seats remain!
The focus of the course is to help those new to the enterprise server infrastructure concepts become… Read more
What with the #sqlnewblogger effort we’ve been seeing a lot of new bloggers (and some old ones starting up again) and there is one thing that seems to come up over and over again.
How often should I blog?
Let’s start with how often I blog. I post twice a… Read more
What servers need the most attention when it comes to I/O? When I increase the memory on a server what effect does it have on I/O? What was it before the change and what was it afterwards?
These are tough questions, and I have a script that I hope will… Read more
Here’s a new feature that I like very much: Limiting exposure of sensitive data like user emails, phone numbers, addresses, credit card numbers and so on.
This feature has been available in the Azure SQL Database for a while and now it is included in the new SQL Server 2016… Read more
Sometimes it does feel that a problem is a database problem until proven otherwise. When this does occur I have had to put a lot of time and effort into demonstrating the hows and whys. One of the easiest ( and most common ) scenarios of this is related to… Read more
Last Thursday I presented my session “From XML to JSON” in the Application Development PASS Virtual Chapter. The session is about XML and JSON, two widely used markup languages, shared by many applications and data platforms. XML has been natively supported in SQL Server since 2005, and JSON is… Read more
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the top 3 settings that have become a best practice for configuring a fresh instance, unless there are some very special reasons to not touch them. However, relevant documentation… Read more
Network Binding Order Warning One of the more common errors I see when setting up a Windows cluster (usually in preparation for a SQL Server Failover Cluster Instance or a SQL Server Availability Group) is regarding an incorrect network binding order. You will see this presented as a warning in… Read more
I started using a standing desk a few years back. While visiting the Redgate Software office, I saw one of my coworkers standing and using boxes of books to lift their keyboard and mouse. I tried that.
It worked OK, and I found myself… Read more
To support Microsoft with the upcoming release of the SQL Server 2016, OH22 have decided to open another public 2-days deep dive workshop on Columnstore Indexes.
This public workshop will take place in Cologne on 10th & 11th of May 2016, at Microsoft Germany office in Cologne (Notice that… Read more
Recently, a customer mentioned that they seemed to be missing records in tables they don’t delete from. Generally, at this point the first thoughts would be user error or code problem or even someone fiddling in the database. But having dug deeper into this, I came across this “feature”.… Read more
The CSS SQL Server Engineers have released a post showing that consistency checks using DBCC CHECKDB is faster and scales better in SQL Server 2016.
This is great news for all of us, especially if you are struggling to get all of your maintenance done within your allotted maintenance window. Read more
I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup in a user database. There was a mention that data was not being distributed evenly across files and also that a trace flag was needed… Read more