This new series examines methods and procedures to check the status of the Operating system, SQL Server instances and databases, using Windows PowerShell. Part One illustrates how to create a PowerShell script to ping the host machine and how to source the PowerShell function and call the function.
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
Generate formatted reports specifically for executives using PDA devices.
I spent most of my time at TechEd two weeks ago, volunteering to answer attendee's questions at Microsoft's SQL Server 2008 booth.
Create a computed column in SQL Server using XML data and optimize SQL queries. Learn how to create a function for XQuery and use it within the computed column formula.
Learn how to build a B-tree similar to those used by databases to implement indexes.
By Steve Jones
Houston AI-Lytics 2026–Powerpoint Slides Thanks to everyone for attending my session on running a...
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Comments posted to this topic are about the item Let's Talk Community Events!
Hi as shown below a replication target requires a primary key. if we want...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers