My 2013 SQL Saturday Schedule!
I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m...
2013-05-16
616 reads
Bill Gate’s speech
One of my friend shared this content. I’m just sharing with you all.Good one and I like it pretty much!!!!Bill...
2013-05-16
616 reads
Len() and DataLength()
Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main difference of those 2 is that Len() gets the...
2013-05-16
12 reads
Len() and DataLength()
Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main...
2013-05-16
1,321 reads
Magnify SQL Text with SSMS 2012
This is just a quick tip to help with folks who present SQL code at events such as SQL Saturday....
2013-05-16
842 reads
Rated R (A Teaser)
How many lines of TSQL codes and Window Functions you need to come up with this?
With R, it takes about...
2013-05-16
908 reads
Lost Phone, Ring,Glasses,Etc, At the Office
If you work at a company with more than a 100 or so employees you probably get an email every...
2013-05-16
631 reads
From Google Reader to Feedly
I shifted to Reader about a year ago mainly for the ability to access my feeds on multiple devices. I’ll...
2013-05-16
638 reads
DMV-11 : T-Log space used by transaction……..sys.dm_tran_database_transactions
sys.dm_tran_database_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms186957.aspx
Returns information about transactions at the database level.
Some time , T-log...
2013-05-16
2,012 reads
Xp_readerrorlog in SQL Server 2012
I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog...
2013-05-16
1,647 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers