Article: How to use temporary table in function
Steve Jones from voiceofthedba.com, editor on SQLServerCentral.com gave me an opportunity to publish humble article about workaround solution for using...
2011-07-21
507 reads
Blog Posts
Bad Admins: Pocketing Backups
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-21
732 reads
Cursor in sql server
Sometimes our application required a database object which allows manipulation of data from a set of rows on row by row basic...
2011-07-21
2,691 reads
Gaining Speaker Experience Credentials, Part II
In a previous post I gave suggestions on how to get speaking credentials for consideration at a larger event, such...
2011-07-21
949 reads
Partial name matching in SQL Server 2011 “Denali”
While playing with SQL Server 2011 “Denali”, I’ve accidentally found out that it has slightly enhanced intellisense in SSMS. There...
2011-07-21
1,389 reads
PowerPivot - Diagram View
The new “Denali” PowerPivot has a lot of fanatic new additions that I’ve really been looking forward to.Many of my...
2011-07-21
2,656 reads
SQL Server Denali CTP3 Download
AdvertisementsMicrosoft has given the SQL Server Denali CTP3 (Community Technology Preview) for public preview. You can download the SQL Server Denali CTP3...
2011-07-21
951 reads
SSWUG Spring Conference Speaker Ratings
This spring I presented a few sessions at the spring SSWUG virtual conference – DBTechCon. Now that the event is over,...
2011-07-21
1,034 reads
Tallahassee User Group meeting August 9th
For those of you in the Tallahassee, FL area on August 9th at 6:00 pm I will be speaking virtually for...
2011-07-21
768 reads
Trusts Are Transitive
If you’ve done networking in the MS world you know about the trust options between domains, and one of the...
2011-07-21
977 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers