INSERT INTO Reading2011 VALUES…
Last Friday I posted a short note on what books I have read this year past, so this Friday keeping...
2010-12-17
511 reads
Last restart of SQL Server
Occasionally I need to see what the date of last restart of SQL Server. The old method isto check the...
2010-12-17
1,083 reads
T-SQL Tuesday #13 Roundup
After my call for “What the Business Says Is Not What the Business Wants”, there were quite a few people...
2010-12-17
1,321 reads
Denver SQL Server User Group Holiday Party
Tonight was the 2010 Denver SQL Server User group party. I typically haven’t done in the past to the holiday...
2010-12-16
1,161 reads
Behold, SSIS Advanced Editor for Data Source Components
It's not everyday that one of your information vendors decides to change the format of its data feed. Evidently, today is not every day. It would be one thing...
2010-12-16
23 reads
Behold, SSIS Advanced Editor for Data Source Components
It's not everyday that one of your information vendors decides to change
the format of its data feed. Evidently, today is not every day. It would
be one thing...
2010-12-16
31 reads
Behold, SSIS Advanced Editor for Data Source Components
It's not everyday that one of your information vendors decides to change the format of its data feed. Evidently, today...
2010-12-16
838 reads
Notes from the December 2010 OPASS Meeting
Our December meeting was a time for a lot of changes:
New location, the Hampton Inn in Lake Mary. It’s further...
2010-12-16
593 reads
Powershell, Me and the MCM
If you haven’t heard yet, Microsoft has made some significant changes to the MCM program. The changes make the certification more accessible to the masses. You can read more...
2010-12-16
7 reads
Powershell, Me and the MCM
If you haven’t heard yet, Microsoft has made some significant changes to the MCM program. The changes make the certification...
2010-12-16
884 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