Upgrading to SQL Server 2005: A dozen must-have tips
We've compiled a list of our dozen most popular tips in the area of upgrading to SQL Server 2005 and they run the gamut.
2007-09-18
4,268 reads
Administration
2007-09-16
2,183 reads
Setting Up Delegation for Linked Servers
Learn how to set up delegation on your SQL Server instances, so you can use the impersonate options when setting up the security properties of linked server definitions.
2007-09-11
2,732 reads
Finding Column Dependencies
Most experienced DBAs know that sysdepends is not very reliable, so how can you find the dependencies inside your database? New author Christian Buettner brings us his technique for finding those hidden dependencies based on your query plans.
2007-09-10
8,823 reads
Getting SQLAgent to Respond Faster
One limitation of SQLAgent is that granularity to which you can schedule jobs: every minute. Sometimes there are things that you would like to happen more frequently, like alerting. Johan Bijnens brings us a technique for getting your SQL Agent to respond to alerts in as little as every 10 seconds.
2007-08-16
5,836 reads
2007-08-15
2,112 reads
Avoiding Microsoft SQL Server 2005 deployment pitfalls
This tutorial shows you how to properly install Microsoft's SQL Server 2005, avoiding the pitfalls of an unsuccessful deployment.
2007-08-15
2,433 reads
2007-08-13
2,580 reads
2007-08-07
1,690 reads
2007-08-06
1,703 reads
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
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 Galunggung Telp:08218154398
WhatsApp:0821-8154-398 Jl. Galunggung No.65 11 dan 65/A1, Gading Kasri, Kec. Klojen, Kota Malang, Jawa...
Alamat Kantor BCA KCP Galuh Mas Telp:08218154398
WhatsApp:0821-8154-398 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
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