Women and Men - Same or Different?
Today we have a guest editorial from Wendy Pastick, co chair of the Women in Technology Virtual Chapter. Today Wendy takls about how men and women handle their careers.
Standardize data storage for geography spatial data type in SQL Server
Geography is one of the spatial data types introduced in SQL Server 2008. One of the characteristic of the geography data type is that it can accommodate any supported geometry based on any supported spatial reference system in the same field. So if the data that is stored in a column of geography data type is not standardized, it can be a very tedious and resource intensive task to figure out the geometry and spatial reference system associated with each value. To deal with this issue, we need to standardize the data stored in a field of that has the geography data type and in this tip we will look at how to deal with this issue.
The Lone Ranger And Data Integrity
Many IT Pros can relate to the the Lone Ranger. With the aid of but one trusty side kick, the...
Partitioning in SQL Server 2008
This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.
PowerShell Version 2: What is new and why is it important?
It was a year ago that Microsoft shipped PowerShell 2. Jonathan Medd lists the top ten reasons why PowerShell 2 should be an important tool for your work
SQL Saturday 52 Recap
I spent this past weekend traveling to and attending SQL Saturday Colorado in the outskirts of Denver. This was the...
SQL Saturday#52 – Colorado Recap
This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it,...
The SQL Server Quiz
There's a SQL Server quiz taking place during the next 31 days, challenging you to answer questions from a number of SQL Server experts and MVPs.
Moving Indexes with Powershell and SMO
Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.
Planning for Failure
Today Steve Jones reminds us that the small disasters are likely to occur, and that you need to be sure that you're planning for them, and practicing for the recovery that will be needed.
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