Re-blog – July 15-July 21
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-07-22
627 reads
SSRS: Dynamic Data Sources
I have been building dashboard using Reporting Services (SSRS) for a client of mine. The dashboard is going to be...
2011-07-22
7,965 reads
Bad Admins: Stealing the SQL Server Service Account
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-22
1,378 reads
Conditionally summing up values in a dataset in SSRS
Recently I had situation wherein I had to conditionally sum up a data set and display the value in a...
2011-07-22
18,021 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,391 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,696 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
981 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
953 reads
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
513 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
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers