SSIS Training Live and In-Person
MVP and author of our Stairway Series on SSIS, Andy Leonard, is holding an SSIS class this December in northern Virginia. If you are interested in top notch SSIS training, read on.
The SQL Server MCM Training Has Changed
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft...
Improving Database Design and Performance Using Compression
This article attempts to show a practical scenario on improving DB design and performance through row density and compression in Microsoft SQL Server 2008.
SQLServerCentral Webinar #5 - Powershell and Source Control
MVP Allen White talked about how Powershell can be used to script out your database and put it in Source Control, and how SQL Source Control from
The DBA Disconnect
It seems that there is a disconnect between how technical people view security and how business people see it. Steve Jones talks about the problems that we have in trying to secure the systems we manage.
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
SQL Server Agent Job Management Scripts
In a previous tip, the tip reviewed several steps for a better and improved environment for scheduled jobs. I am totally convinced with the recommendations and want to implement these for my scheduled jobs. To make this easier, I want to create a template so I can produce a suitable and reliable way of updates for my production server. In this tip I provide a step by step exercise to perform on a test server to prepare the customized and tested scripts to run on the production server.
Are You a Ten?
Are you truly an expert in SQL Server? Would you claim to be a 10 on a scale of 1 to 10? Steve Jones notes that the product is so wide and deep that it's unlikely any of us will be an expert in most of SQL Server, and that's OK.
SQLServerCentral Webinar Series #5: Setup Your Source Control With Help from PowerShell
MVP Allen White shows how he can use Powershell to setup SQL Source Control from Red Gate Software on Nov 18, 2010.
Handy Hardware Assessment Tools For SQL Server
Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers