Create a Performance Baseline Repository
This article demostrates how to create a Baseline repository that holds summarized data of all SQL Executions executed on an instance of SQL Server.
Announcing the New PowerShell Virtual Chapter of PASS!
PASS is launching a new PowerShell Virtual Chapter. It's first meeting is next Wednesday at 12 pm EDT.
Risk Analysis
This Friday Steve Jones asks about your spending on Disaster Recovery and is it in line with the risks involved.
Sending multiple rows to the Database from an Application: Part I
New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.
Manage Database Projects With Visual Studio 2010
This article demonstrates how to manage database projects with Visual Studio 2010.
Data Distribution - Part 2
In the second part of this series, Leo Peysakhovich provides a mechanism for tracking real time data changes.
Free Training Webinar Series - October
A series of free webinars from Pragmatic Works that cover a variety of topics in October.
From One of the Pack to ‘Top Dog’ – Honeymoon Period Over!
In part two of his editorial series on moving to being a manager, Justin H-Davies talks about the challenges that are evolving of being a manager.
A Haunting TSQL Tuesday Tale
Time for the ghouls and goblins to come out of the woodwork once again for another tale of deception and...
Policy-based Management and Central Management Servers
Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices. It is even better if you can also manage your servers centrally, and monitor that they are all adhering to company policies.
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 KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
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