SSMS 2016 Bug
I have been using SSMS (SQL Server Management Studio) 2016 build number 13.0.15900.1 and noticed that if you wanted to...
2016-10-27
645 reads
Arun Sirpal
More bytes for Row versioning
I like row versioning– see this link for more details: https://technet.microsoft.com/en-us/library/ms189122(v=sql.105).aspx If your database is enabled for one of the...
2016-10-26
366 reads
Azure App Service Companion for iOS
This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt...
2016-10-25
467 reads
The dark side of Fn_dump_dblog
I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are...
2016-10-24 (first published: 2016-10-17)
1,964 reads
Another way to move SQL DB to Azure
About 8 months ago I wrote an article (http://www.sqlservercentral.com/articles/SQL+Server/139998/ ) where I showed you how to migrate your “earth” SQL Database...
2016-10-20
462 reads
Azure SQL Database DMVs
The following DMVs shown within this blog post are some of the more common ones that I am finding really...
2016-10-18
477 reads
Microsoft Certifications
Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...
2016-10-13
526 reads
SSMS 2016& Azure SQL DBs
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that...
2016-10-11 (first published: 2016-09-27)
1,492 reads
Azure SQL Database – TDE
I work in the financial space so you can imagine that security is quite high on the agenda. TDE (Transparent...
2016-10-10
442 reads
SQL Performance Dashboards – update
SQL Server Performance Dashboards – update The first article that I ever wrote (http://www.sqlservercentral.com/articles/SQL+Server/127992/) was last year where I wanted to...
2016-10-07
623 reads
Blogs
T-SQL Tuesday #193 – Notes to my past self and from my future self
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
A Note and a Message: T-SQL Tuesday #193
By Steve Jones
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...
Forums
This doesn't make sense to me - making me crazy - er
Hi So I have the below select query that won't return results if I...
Catalog max connection pool size: 100
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers