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
470 reads
All About SQL
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
484 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,982 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
534 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
452 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
625 reads
ALTER INDEX….ABORT!
I know there are people out there that will be going from older versions of SQL to SQL Server 2016, yes...
2016-10-06
489 reads
Detaching corrupt databases
Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL...
2016-10-04
606 reads
Query Store – Quick Tour
The query store, Borko Novakovic Senior Program Manager from Microsoft calls this feature “Similar to an airplane’s flight data recorder”....
2016-10-03
459 reads
My application to Microsoft
I have been eager to write this blog post for a while now. I want to share my experience of...
2016-09-29
878 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
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...
Forums
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers