Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4
This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.
Charlotte's SQL Server User Group
If you're in the Charlotte, NC area, the user group is meeting on October 16, 2007
The Pay Jump
Workers Rarely Jump Ship Over Pay Alone is an article that I saw awhile back and saved. It is 100% true and should be required reading by every C-level knucklehead and MBA student.
Who wants to be a SQL Server DBA?
A look at how one of our longtime members goes about hiring new DBAs.
Restore your SQL Server database using transaction logs
Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore a SQL Server database to a point in time to recover a data table.
Fun with Computers
The whole entertainment aspect of computing is growing tremendously and we're slowly seeing a convergence in our living rooms of computing capabilites along with entertainment. From rocker chairs with speakers to TiVo-type devices, the Nokia Internet Tablet, and XBOX 360s and Playstations that can enhance our movies.
Survive A SQL Server DBA Technical Interview
Another little bit of career advice, this time from longtime author Jeffrey Yao who gives you some pointeres on what you should know for your next job interview.
Are key performance indicators a true measure?
Some managers love to look solely at numbers when assessing performance, and key performance indicators (KPIs) are right up their street. But how useful are they in the context of software development
Collation Error 468
Most DBAs don't ever deal with multiple languages or different collation and sort order settings in SQL Server, but it can be a handy piece of information to have. Steve Jones brings us a quick look at a problem in comparing data across databases.
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers