SQL Server Default Trace
The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in...
2010-02-04
3,886 reads
oPASS Meeting Reminder – February 9, 2010
Our next meeting is February 9, 2010, We’ve got Ronald Dameron coming to speak this month on Database Hardening using...
2010-02-04
326 reads
SQLSaturday #42 Announced!
Dave Schutz will be leading the first ever SQLSaturday in Columbus, OH on June 5, 2010 at the Fawcett Center...
2010-02-04
334 reads
I think it’s a hole
The other day I was trying to help someone that had removed the BUILTIN/Administrators logins from their instance without first...
2010-02-04
817 reads
Three Things That Got Me Here
Tim Mitchell (Blog | Twitter) and Jack Corbett (Blog | Twitter) both tagged me in the latest meme circulating through the SQL...
2010-02-04
560 reads
Troubleshooting and Optimising SQL 2008 Reporting Services Configuration for Microsoft Dynamics CRM 4.0
Recently we have been struggling with configuration and installation of SQL Server Reporting Services 2008 when there was a co-existing...
2010-02-04
4,172 reads
February Question: What is one of your best practices for making full backups and transactions log backups of your production databases?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-02-04
578 reads
SSMS and Visual Studio Tip
Did you know that if you right-click on a tab in SSMS or Visual Studio you get the option to...
2010-02-04
564 reads
SSIS Alpha Splits using the CODEPOINT() Function
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
2010-02-04
4,410 reads
PASS Update #23
January has been a slow month for me as far as PASS involvement, I show about 10 hours logged for...
2010-02-04
460 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers