Video Featured on SQLShare
I didn’t have a chance to blog this yesterday (January 11, 2010), but my most recent video, Dynamic SQL Using...
2010-01-12
479 reads
T-SQL Tuesday #2 – Data Conversions
Adam Machanic started the idea of a blog party last month, getting people to write about date and time issues...
2010-01-12
1,693 reads
January OPASS Meeting Tonight
Tonight is the January meeting for OPASS and we have a great schedule for the evening.
Robert Hurwitz a developer for...
2010-01-12
384 reads
T-SQL Tuesday #2 – Data Conversions
Adam Machanic started the idea of a blog party last month, getting people to write about date and time issues...
2010-01-12
524 reads
SQL Lunch #8 – SSRS Data Driven Subscriptions (Devin Knight)
Join Devin Knight for a SQL Lunch at 12:30 EST today to hear about using the SSRS Data Driven Subscriptions!...
2010-01-12
815 reads
Installing WordPress
Last week I posted about Picking a Blog Platform on some of the process that lead to me moving to...
2010-01-12
745 reads
Intel Intelligent Home Energy Management
Last week at CES 2010, Intel showed off a proof of concept device for a home energy management dashboard. This...
2010-01-12
996 reads
Finding Invalid SQL Logins
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
2010-01-12
5,069 reads
A Time and a Place for the SQL Server Maintenance Plan Wizard
Reprinted from my editorial in Database Weekly.
In the course of my job, I get to give a lot of presentations,...
2010-01-11
369 reads
Lock configuration setting and preventing locking contention
The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this...
2010-01-11
734 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
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...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
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