Category Archives: SQL

Great post on Compression Options

Posted on October 8, 2015 by paulwinans

We are in the process of implementing Columnstore Indexes. I came across this page while researching and shared it with the DBA Team. http://aboutsqlserver.com/tag/clustered-columnstore-indexes/

Posted in Configuration, DBA, SQL | Leave a comment

Querying Tidal for Job Status

Posted on May 2, 2015 by paulwinans

The need to look to the future for what is going to run and easily make a report does not appear possible through the Tidal Scheduler interface. Here is what I wrote to meet this need: use Admiral select — top 100 … Continue reading →

Posted in SQL, Tidal Enterprise Scheduler | Leave a comment

Using SQL To Configure Database Mirroring

Posted on January 3, 2015 by paulwinans

We use database mirroring for replicating data from physical sql servers to the disaster recovery location; SRM is used for virtual machines. I don’t like the point and click interface though. So many screens for a pretty simple series of … Continue reading →

Posted in Configuration, DBA, SQL | Leave a comment

The Road to Awareness (aka Event Notifications)

Posted on December 13, 2014 by paulwinans

Getting notified of what is going on is critical to meet SLAs. Plus, who wants to be the second to know about something going on with a production sql server? No thanks. SQL Alerts serve their purpose. The cache hit ratio … Continue reading →

Posted in DBA, SQL | 2 Comments

The Code Review

Posted on July 9, 2014 by paulwinans

At work, some years ago, I was able to implement a dba code review and practice deployment requirement for every Change Request. (A Change Request documents the proper steps have been taken so that a deployment has a good chance of success.) This was … Continue reading →

Posted in DBA, SQL | 2 Comments

Updating Statistics

Posted on June 6, 2014 by paulwinans

Statistics and sql server. When people ask me what are statistics I answer with a Google maps analogy: while we know the roads are there, the traffic changes and, therefore, in the same way we know it is best to patiently … Continue reading →

Posted in Configuration, DBA, SQL | 2 Comments

Execute As

Posted on December 17, 2013 by paulwinans

We all want to have our databases not owned by an individual. Especially the model database. We can run alter authorization on database::<<db name>> to sa after the fact, but why make a problem? An easy way to avoid this … Continue reading →

Posted in Configuration, DBA, SQL | Leave a comment

Searching RDLs

Posted on November 10, 2013 by paulwinans

As the company is moving, we needed to search for hard coded address data in all the reports. This smart individual came up with an easy way to extract all the RDLs from the reportserver database. I was especially impressed … Continue reading →

Posted in SQL, SSRS | Leave a comment

Educating Your Developers

Posted on October 19, 2013 by paulwinans

Great departments have great people. No kidding! How do we end up with quality developers? Time has shown it we can’t hire the best for every position and, inevitably, something will come up which will require growth, whether personal or professional, … Continue reading →

Posted in DBA, Leadership, SQL | Leave a comment

Hard Coded Values

Posted on April 12, 2013 by paulwinans

Often we see code with business logic in the form of hard coded values. For example, a long, comma separated IN statement which lists out a category. These comma delimited lists are of course data duplication, nothing anyone wants. It would be worth … Continue reading →

Posted in DBA, SQL | 2 Comments