Welcome to 2011
After the holidays, Steve Jones welcomes everyone in the SQLServerCentral community to the new year and talks about goals and your career.
Can You Dig It? – StmtCursor and StmtReceive Elements
She can dig it!
D Sharon PruittA few posts ago in the plan cache series I discussed the children for the...
Identity Property Range Checking in SQL Server
This article examines practical methods of managing and monitoring large tables which make use of the IDENTITY property.
Being Careful with Power
It's good to be careful with your power consumption, especially as the power cost of computing continues to grow. However with your SQL Server, you don't want to be too careful, as Steve Jones notes.
Clouds Are In our Future
Today we have a guest editorial from Andy Warren looking at the future of cloud computing and SQL Server.
How to check SQL Server Authentication Mode using T-SQL and SSMS
Many times developers want to put logic into their code or SSIS/DTS package to check the SQL Server authentication mode. How can this be done programmatically?
SQL Server Workload Types and Hardware Selection
There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction...
Enjoying the New Year
For the last Friday poll of the year, Steve Jones has a fun one. Add your input and give everyone an idea of how to spend the last part of this holiday season.
Generating SQL Server Test Data with Visual Studio 2010
As a database developer or tester sometimes you need to have production like data in your environment for your development or testing, but you cannot have the production data because of security and privacy issues. So how you can generate test data or replicate similar data as in production for your development or test environment?
Getting a Dedicated Admin Connection
Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need...
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers