by Steve Bolton
As users become more familiar with software, they typically follow a progression that begins with learning the...
2013-03-14 (first published: 2013-03-11)
3,141 reads
This last weekend I attended my first SQL Server Saturday event. The event was held in The Jury’s Inn in...
2013-03-11
838 reads
How many times have you been asked to develop a report that displays the details for a specified group? For...
2013-03-11
3,075 reads
A common request from business users is ‘Time Intelligence’ functionality in an SSAS cube. For example, users may wish to...
2013-03-11
5,684 reads
sys.dm_exec_sessions DMV (Dynamic Management View), delineated by BOL as follows: http://msdn.microsoft.com/en-us/library/ms176013.aspx
Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a server-scope view...
2013-03-11
3,794 reads
Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic...
2013-03-11
837 reads
As a DBA in a complex environment, we frequently need to backup various environment information. One of the backups is...
2013-03-10
1,065 reads
Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it. We know...
2013-03-08
4,693 reads
I use the Google calendar service extensively. I host my domain there and I’ve gotten used to the calendar. When...
2013-03-08
1,134 reads
Next Tuesday, March 12th at 1:15pm CST, I will be presenting the session “Top BI Enhancements for SQL Server 2012” at...
2013-03-08
843 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers