Paging Doctor Powershell
Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.
2014-04-11 (first published: 2011-04-04)
12,559 reads
Articles
SQL Saturday #285 Atlanta
SQL Saturday will come to Atlanta on May 3, 2014. This is a free, full-day event of SQL Server training and networking. SQL Saturday #285 also has 3 (paid for) pre-con sessions available run by Kalen Delaney, Teo Lachev, and Denny Cherry. Make sure to register for SQL Saturday while spaces are available.
2014-04-11
360 reads
The DBA Detective: Disturbing Developments
Originally one of the articles in the first DBA Team series, Grant wonders what Raymond Chandler or Dashiell Hammett would have done if asked to write technical articles for Simple-Talk. He came up with the DBA detective, hard-boiled Joe Dee Beay.
2014-04-11
3,702 reads
How to create an SSIS conditional data flow task
This article demonstrates how to selectively channel records from a flat-file data source to separate destination tables in an SSIS package using a combination of multicast, data-conversion and conditional-split data flow transformation elements within a data flow task.
2014-04-10
17,832 reads
Managing SQL Server Services with PowerShell
PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets.
2014-04-10
3,950 reads
How much overhead does encryption add to a SQL Server query
If you have been in the information technology industry long enough, you have probably heard the expression "this adds overhead" when discussing any extra processing added on to what is considered normal processing. Dallas Snider answers the question of additional overhead caused by encryption.
2014-04-09
4,230 reads
Divide and Conquer - Performance Tuning
Sometimes we need to break down a complex problem into a multiple stage solution to achieve optimal performance
2014-04-08
8,542 reads
14 SQL Server Indexing Questions You Were Too Shy To Ask
The first thing you need to understand about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of these questions about SQL Server Indexes and indexing.
2014-04-08
10,155 reads
SQL Saturday #289 - Orange County, CA
SQL Saturday is coming to Huntington Beach, CA on April 26 2014. This is a free day of training and networking for SQL Server Professionals - there are also 2 paid-for precons on April 25 presented by Jason Horner and Bradley Bell. Register for SQL Saturday Orange County while space is available.
2014-04-08
1,761 reads
Load Testing in a Big Data Environment
Load tests give the database administrator quite a lot of valuable information and may make the difference between poor and acceptable application performance. But are there any gotchas or traps associated with big data?
2014-04-07
4,112 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers