S–3–X Talk Week: Love, HR, and Sexy Shoes
We’re conducting S–3–X Talk Week here at the MidnightDBA #Awesomesauce blog. In the tradition of the first S-3-X week blog,...
2010-10-13
853 reads
SQL Awesomesauce
S–3–X Talk Week: This Totally Won’t be Awkward
We’re conducting S–E–X Talk Week here at the MidnightDBA #Awesomesauce blog, in honor of everyone’s favorite subject. In deference to the...
2010-10-11
526 reads
Forgotten T-SQL Cheat Sheet
You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet!
Yessir,...
2010-10-11
1,419 reads
New Hotness: sys.objects and sys.schemas
Last month we talked about the old and busted syscomments- and the new hotness that is sys.sql_modules – for pulling code out of...
2010-10-08
683 reads
Today I Blog About Certifications (Instead of Studying)
I'm not in it for the money...exclusively...
I was talking to the older kids about homework yesterday, and I mentioned that...
2010-10-07
706 reads
How MUCH More Do You Make?
Yesterday, my SQLServerCentral.com editorial Why are we still talking about Women in Tech? was published, and we had a fine...
2010-10-07
948 reads
Tip: OVER and PARTITION BY
Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful…
OVER
OVER allows you...
2010-10-05
2,631 reads
Dear Users…Sincerely, Your IT Guys
Dear Users,
We, the tech people, understand that you just want technology to work so you can get your jobs done. ...
2010-09-30
1,702 reads
How to Prove a Fact (Again)
Sean’s latest rant – about a vendor with a dangerously small amount of SQL knowledge – has spurred me to talk about...
2010-09-29
1,474 reads
Journal: SQL Saturday #52
Friday
6am – up to catch an 8:30 flight. My daughter Lisette is going with me on this trip.
9:30am local time, we...
2010-09-27
684 reads
Blogs
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers