Find your Enabled SQL Server Network Protocols Using PowerShell
Another quick check I like to do when in 'discovery mode' on a client system is to see what network...
2011-05-21
1,983 reads
Allen White
- Interests: Running, Theatre, Flying, SQL Server
Quickly Find Your DDL Triggers with PowerShell
As a consultant I spend much of the first day or two at a client site discovering everything I can...
2011-05-20
1,303 reads
Change SQL Servers Authentication Mode with PowerShell
Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One...
2011-05-19
5,580 reads
PASS Summit Session Selection is Open
This year the Program Committee decided to open up the selection process to the community. I'm anxious to see how...
2011-05-11
847 reads
Don't Do This
In working on applications at client sites you tend to come across code that makes you think "what were they...
2010-06-25
900 reads
PowerShell Script to Remove Old Backups
A Twitter user asked for a script to remove old backups, and I had one I built back in February,...
2010-06-24
1,119 reads
Lots of Speaking Engagements Coming Up
SQL Saturday - Columbus, OH, June 26, 2010 I'll be presenting two sessions this Saturday (June 26, 2010) in Columbus, OH...
2010-06-23
622 reads
TechEd 2010 Followup
Last week I presented a couple of sessions at Tech Ed NA in New Orleans. It was a great experience,...
2010-06-13
730 reads
Service Broker Solutions - Don't Forget the Basics
After finally getting a Service Broker solution implemented successfully, I'm really impressed with the technology, and frustrated how difficult it...
2010-04-03
893 reads
Document, Document, Document
A while back I blogged about using Checklists , but there's another task you want to incorporate into your workflow - documentation....
2010-03-13
1,198 reads
Blogs
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
FIRST_VALUE vs. Min: #SQLNewBlogger
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
This post comes off the back of my last, where I looked at issues...
Forums
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
Duplicate Documents
Hi Experts, I am trying to find duplicate documents stored in our Filestream database....
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT * FROM Sales.SalesOrderHeader AS soh WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)See possible answers