Twas the Night Before Christmas - SQL Style
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
Twas the Night Before Christmas - SQL Style
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
Twas the Night Before Christmas - SQL Style
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
CLR Table-Valued Function Example with Full Streaming (STVF / TVF)
SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and easy method. Solomon Rutzky brings us an article that givse you an example you can extend to your environment.
Is It Worth Upgrading to SQL Server 2008
New author Nigel Maneffa brings us a look at SQL Server 2008 and its new features, trying to decide if it's worth the upgrade.
The Balance of Resources
Companies have to make choices about what to spend money on, often not using the same priorities as those in IT might choose. Steve Jones talks about some of choices they make and why their decisions might make some sense.
Script Task/Component and Template Information
The Script Task and Script component are often used by people developing SSIS packages because they are easy to use and now because SSIS could be perceived to be more developer friendly they are very powerful. That being said we should no be using them everywhere.
The Balance of Resources
Companies have to make choices about what to spend money on, often not using the same priorities as those in IT might choose. Steve Jones talks about some of choices they make and why their decisions might make some sense.
The Balance of Resources
Companies have to make choices about what to spend money on, often not using the same priorities as those in IT might choose. Steve Jones talks about some of choices they make and why their decisions might make some sense.
Can Users Be Trusted?
Can we trust users to make good decisions about what to install on their devices? Steve Jones says that the Apple iPhone model has some good advantages and it might work well for SQL Server as well.
Blogs
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Forums
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
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
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