Tags » Microsoft SQL Server

Excel to Compare databases for changes

Interesting request the other week.

I had copied data from one Sql Server database to another, because to do an in-place update of the fields kept falling over. 425 more words

Microsoft Sql Server

Webinar Available On Demand - Building an Auditing Framework for SQL Server

Recently I gave an introductory webinar on how to build an auditing framework for SQL Server. The focus was for those tasked with auditing SQL Server on a regular basis and needing some ideas of how to get started. 56 more words


Installing SQLCMD

For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says anything I want to point out that yes, I realize that you can use Powershell instead. 222 more words

SQLServerPedia Syndication

SSMS Running remotely

To run SSMS remotely:

runas /netonly /user:domain\username “C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe”


runas /netonly /user:WIN-P9OQ9GF24HV\justdave “C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe”

Microsoft SQL Server

Using Snippets

A while ago I talked about Templates. This is an easy way to get a, well, template of a piece of code. But a much faster way to get a simple template is to use a… 200 more words

SQLServerPedia Syndication

Large MSDB From Hidden sysxmitqueue Table

— by Lori Brown @SQLSupahStah

Recently, I was checking on some of the servers that I manage and found that one had an 8GB msdb database. 598 more words

SQL Server

Too many indexes!

Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.

Different indexes work best for different queries. In a system with a lot of queries that means we could need a lot of indexes. 1,925 more words

SQLServerPedia Syndication