PASS Summit Schedule
Earlier this week, PASS opened up the Schedule Builder for the those that are registered for the PASS Summit. You...
2010-09-30
1,560 reads
No Guarantees
The keynote for SQL Saturday #52 in Denver, that didn’t go as smoothly as I’d like due to technical difficulties,...
2010-09-30
1,524 reads
Upcoming Florida Events
Lots of events in Florida, easy to lose track! The Tallahassee Code Camp is October 23, 2010, details at http://www.tallycodecamp.org/...
2010-09-29
1,684 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,477 reads
Index Operations Showdown: Drop & Create vs. Create With Drop_Existing vs. Rebuild
Every now and then you may have had to move nonclustered indexes between filegroups. There are two ways it can...
2010-09-29
5,052 reads
The Lone Ranger And Data Integrity
Many IT Pros can relate to the the Lone Ranger. With the aid of but one trusty side kick, the...
2010-09-29
2,207 reads
A Small Selection of SQL Azure System Queries
I had a question come up during my “Getting Started with SQL Azure” presentation at SQLSaturday #52 in Denver last...
2010-09-29
1,608 reads
Grabbing SWAG
It’s getting close to the time for the SQLServerCentral party events this fall, and time to start gathering up SWAG...
2010-09-29
1,823 reads
Don’t Take me (too) Literally
Years ago I was part of a heated discussion about the ability/inclination of a team I was on to build...
2010-09-29
1,534 reads
Common SQL Server Mistakes – Indexing Every Column
If one index helps speed up queries, than more indexes should help more, right? They do, but they also come...
2010-09-29
4,791 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
Alamat Kantor BCA KCU Tasikmalaya Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. HZ. Mustofa No.300, Tuguraja, Kec. Cihideung, Kab. Tasikmalaya, Jawa...
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
Alamat Kantor BCA KCU Dago Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung,...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers