Excel Within Management Studio
Aaron Bertrand has put in a Connect request for a feature whereby data returned as a grid from a query...
2010-01-13
751 reads
Blog Posts
Hello SMO (F#) World!
Reading The F# Survival Guide has motivated me to write my version of an F# "Hello World!" utility. What I mean...
2010-01-13
23,336 reads
How to Use SQL Backup Inside a Maintenance Plan
When you create a SQL Server Maintenance Plan using the Maintenance Plan Wizard or the Maintenance Plan Designer, the SQL...
2010-01-13
1,615 reads
LEFT(), or Left Out?
So the question came up earlier today about the RIGHT() and LEFT() functions in the SSIS expression language. Like the...
2010-01-13
667 reads
New Article on Clustering Myths in the PASS SQL Server Standard
The PASS SQL Server Standard has published a new article called “Busting 6 SQL Server Failover Clustering Myths”, by Kathi...
2010-01-13
380 reads
PASS 2009 Evaluation Results
The results are in, and I'm pleased, but not satisfied. I delivered a brand new session called Gather SQL Server...
2010-01-13
413 reads
PASS DBA Virtual Chapter Presentation
I got the opportunity to present to the PASS DBA Virtual Chapter today, discussing the properties and practical uses of...
2010-01-13
926 reads
Primary Key Discovery II
In Part I, I discussed a couple of scripts that could be used to help discover some vital information about...
2010-01-13
648 reads
SQL Pass session evaluations
I finally got the last of my PASS Summit session evals and so, like someotherpeople, I thought I’d make them...
2010-01-13
574 reads
SQL Server Standard Volume 7 Issue 1
Kathi Kellenberger’s fantastic new article is available in the latest issue of SQL Server Standard. There are a lot more...
2010-01-13
839 reads
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...
Alamat kantor BCA KCP Galuh Mas Telp:0817866887
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
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