How Not to Write a Resume Cover Letter
Although I am not currently a hiring manager, I occasionally receive unsolicited resumes from people looking for work. I just...
2010-03-03
1,498 reads
Using the OUTPUT clause to retrieve new identity values from SQL Server 2008
Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity...
2010-03-03
2,740 reads
SQLSaturday #44!
Andrew Karcher and Marlon Ribunal are heading up SQLSaturday #44 scheduled for April 24, 2010 at Golden West College in...
2010-03-03
340 reads
Bookstores and Databases
My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at...
2010-03-03
340 reads
Baby Steps to Learning Something New
I had a really bad habit of trying to jump into the middle of something I didn't know very well,...
2010-03-03
4,813 reads
Notes from the 2010 South Florida Code Camp
Drove down with the family Friday afternoon, not much traffic and a smooth trip. Checked into the Residence Inn just...
2010-03-03
459 reads
Recovering Data and Transactions
Recently I wrote about the disaster recovery issue recently at SQLServerCentral. Someone sent me a note asking why I didn’t...
2010-03-03
390 reads
Mitigating Consulting Risks
In my last post on consulting, Isn’t Consulting Risky?, I contended that in many respects, when done with sufficient forethought...
2010-03-02
1,209 reads
Using Excel 2007 in SSIS 2005
Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade. This...
2010-03-02
1,044 reads
SQL Server - MVP Deep Dives
I got my copy of MVP deep dives earlier this month and have been making good progress in reading some...
2010-03-02
871 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers