Schedule the backup job in Express Edition
Schedule the backup job in Express Edition: Everyone knows that, you cannot schedule a job in Express edition, as Express...
2010-09-08
463 reads
MDX - Calculating the Percent of a Named Set
Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic...
2010-09-08
1,138 reads
A week far away...24 HOP!
I just have an email with notice that 24 Hours Of PASS, is a week far away! Once again great...
2010-09-08
647 reads
Common SQL Server Mistakes – GUID as a Clustered PK
I haven’t been thrilled with GUIDs as primary keys, mainly because I think that it’s hard for humans to work...
2010-09-08
1,475 reads
Speaking at SQLSaturday #48 in Columbia, SC
SQLSaturday #48 is October 2nd, 2010, at Midlands Technical College in West Columbia, SC. I’ll be doing two presentations, one...
2010-09-08
283 reads
New Ideas for SQLSaturday
Jack Corbett and I are trying a few new things at SQLSaturday #49 in Orlando this year (Oct 16, 2010)...
2010-09-08
267 reads
Tip: RESTORE FILELISTONLY / WITH MOVE
As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to...
2010-09-08
1,736 reads
What is Normalization in SQL ?
=> What is normalization ?
Defination :Normalization is the process of efficiently organizing data in a database. There are two goals of...
2010-09-07
303,376 reads
Please don’t Tweet this, but…
This is reprinted from my editorial in Database Weekly.
During some recent conversations, I’ve noticed an increasing tendency for people to...
2010-09-07
555 reads
More Notes on Live Meeting Presentations
Yesterday I did another presentation via Live Meeting, some thoughts from that effort:
Perf VC team did a great job making...
2010-09-07
433 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
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
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