Tuesday
PASS Performance Virtual Chapter - Introduction to SQL Server Statistics - Andy Warren
Wednesday
Idera - Building a Data Mart with Integration Services - Stacia Misner
SQL...
2010-09-03
897 reads
Cross-posted from The Goal Keeping DBA:
Re-learning how to think is always a difficult process. My oldest son is starting the...
2010-09-03
1,491 reads
Members of the securityadmin role can escalate to sysadmin rights. Here's how to restrict them back to 2000 levels.
2010-09-02
6,440 reads
Note: Republishing because the article covering the issue and a workaround has been published here on SSC.
In a recent thread...
2010-09-01
4,304 reads
This is a reminder for those who might be considering submitting a session but haven't yet. The call for speakers...
2010-08-31
1,402 reads
The only scheduled event among the sources I have listed is the one for SQL Lunch, so it looks to...
2010-08-27
594 reads
I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?
2010-08-25
3,618 reads
After going through all the materials provided to the NomCom for the PASS Board of Directors, I think I can...
2010-08-24
1,415 reads
Note: I got some of the dates mixed up, so I'm re-publishing this post.
Monday
SQL Lunch - Troubleshooting SSIS Package Development - Dustin...
2010-08-23
939 reads
Andy Leonard has done an awesome job collecting information and putting the numbers together for the recent candidate decision for...
2010-08-23
1,882 reads
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
hi for the 2 years i've been here I believe we've had "encryption" turned...
Hi I have an overnight process that moves allot of claims records Been working...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers