Finding Invalid SQL Logins
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
2010-01-12
5,067 reads
Blog Posts
IN vs INNER JOIN
Often in forum threads discussing query performance I’ll see people recommending replacing an INNER JOIN with an IN (or recommending...
2010-01-12
21,533 reads
Installing SQL Server 2008 and 2008 R2 on Windows Server 2008 R2
There is a recent post on the Microsoft SQL Server Support Blog about how to get SQL Server 2008 and...
2010-01-12
1,472 reads
Installing WordPress
Last week I posted about Picking a Blog Platform on some of the process that lead to me moving to...
2010-01-12
743 reads
Intel Intelligent Home Energy Management
Last week at CES 2010, Intel showed off a proof of concept device for a home energy management dashboard. This...
2010-01-12
989 reads
January OPASS Meeting Tonight
Tonight is the January meeting for OPASS and we have a great schedule for the evening.
Robert Hurwitz a developer for...
2010-01-12
382 reads
PASS Summit Survey – Check Your Email
Not sure if it went to the entire PASS mailing list or just those that have attended a Summit, but...
2010-01-12
661 reads
Service Broker Basics - Part Deux
Last week I introduced the Service Broker Basics . Today I'd like to cover some of the "plumbing" - the components that...
2010-01-12
477 reads
Setting Goals for 2010
Most people set their New Year resolutions for the new year at this time. We know from history that many...
2010-01-12
359 reads
SQL Lunch #8 – SSRS Data Driven Subscriptions (Devin Knight)
Join Devin Knight for a SQL Lunch at 12:30 EST today to hear about using the SSRS Data Driven Subscriptions!...
2010-01-12
807 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers