Goal Tuesday
Almost halfway into the first month of the new year, Steve Jones reminds us of the power of goals. Today he encourages you to set up your own goals for the coming year.
Run SSIS packages from remote client with stored procedure
By utilizing service broker, xp_cmdshell and dtexec.exe SSIS packages can be run with a stored procedure.
10 Goals For 2010
As is the traditional thing to do at the beginning of a new year I'm making goals for what I'd...
2010 First Quarter Goals
I have been reading several blog postings about 2010 goals. First, I want to applaud all of you for setting...
Data Warehousing 2.0 and SQL Server: Architecture and Vision
Architecture and data warehousing are not static. From the first notion of a data warehouse to a full-blown analytical processing architecture that includes data marts, ETL, near line storage, exploration warehouses, and other constructs, data warehousing and its associated architecture continue to evolve. In 2008, the book on the latest evolution of data warehousing appeared – DW 2.0: The Architecture for the Next Generation of Data Warehousing (Morgan Kaufman). In that book the general architecture for data warehousing in its highest evolved form appeared.
Goal Tuesday
Almost halfway into the first month of the new year, Steve Jones reminds us of the power of goals. Today he encourages you to set up your own goals for the coming year.
Goals for 2010
Posting goals online is great as long as you meet your goals, can be something less than great if you...
Goals for 2010
Last year I wrote about my goals for 2009. Yesterday I looked over them and evaluated my performance. I think...
Goals for 2010
So I’d planned to already have this done and published before the new year rolled around, but life got in...
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
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...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
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