Possible interview questions for Intern/Junior DBA or Developer
I wrote these questions thinking about what some basic t-sql statements that I would want to see if I were...
2008-05-10
3,823 reads
A View Variable
I saw that Erland Sommerskag posted a Connect item that asked for a "View Variable" to be added to the...
2008-05-09
1,262 reads
Follow Up Notes on SQLSaturday #3
Our most recent SQLSaturday went well, but there is always room for improvement. Here are my notes from this event:
The...
2008-05-08
398 reads
A little fun with SSIS Expression Language
The SSIS expression language is a powerful yet enigmatic entity. Once you get used to its syntax - which is part...
2008-05-08
4,891 reads
Kindle Research - Procs and Cons with the Sony Reader
After the editorial on the Kindle, which got quite a few responses, I've continued to look around and research things....
2008-05-08
964 reads
ACM, 5 Year Anniversary, and Customer Service
Time moves by and I was surprised to get a coffee mug in the mail from ACM (Association for Computing Machinery)...
2008-05-07
492 reads
Thoughts on SQL Saturday in Jacksonville
I was able this Saturday to head down to Jacksonville and speak at the SQL Saturday there. There were a...
2008-05-07
728 reads
One More SQL Feature Wish
It would be handy to have a checkbox/SET option/something that would tell SQL not to cache plans run in a...
2008-05-06
425 reads
SQL Backup 5 (Red Gate)
So after many months of trudging through native SQL Server backups for new mission-critical application I'm deploying, I have decided...
2008-05-06
686 reads
Will You Host the Next SQLSaturday?
How to have more SQLSaturdays?
Over the past year we've been working on the ambitious goal of building a national franchise...
2008-05-06
805 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