Version Control your Stored Procedures
This shows a method for generating scripts for SQL Server stored procedures and functions so they can be added to a version control management system (VCMS).
2010-05-06
20,822 reads
Articles
SQL Server Management Features vs Oracle Database Management Features
The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service.
2010-05-06
3,650 reads
Finding Jobs
This article from Tushar Kanti will help you identify the list of all the Jobs related to a Table/View/Procedure.
2010-05-05
6,137 reads
SQL Saturday #38 - Jacksonville
Come attend this great one day free event on the Florida coast on May 8, 2010. There are a number of great speakers that make this worth attending.
2010-05-05 (first published: 2010-04-20)
2,639 reads
SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.
SQL Server provides several system meta data functions which allow users to obtain property values of different SQL Server objects and securables. Although you can also use the SQL Server catalog views or Dynamic Management Views to obtain much of this information, in some circumstances the system meta data functions simplify the process. In this tip I am going to demonstrate some of the available system meta data functions and their usage in different scenarios.
2010-05-05
3,353 reads
Calling exceptional DBAs: step up and be recognized
Nominations for The Exceptional DBA of 2010 open today, giving database administrators around the world the chance to be recognized for service to their employers, the SQL Server community, and the IT industry at large.
2010-05-04
876 reads
Improving Performance of Cross-Partition Queries
Table partitioning was added in SQL Server 2005 and increases performance in most cases but decreases it in others.
2010-05-04
7,438 reads
The Com.PASS Feeds
A new set of RSS feeds, hosted by PASS, bring you a large quantity of SQL Server content from various sites, including SQLServerCentral.
2010-05-04
1,099 reads
How to create Policies using PowerShell scripts
This article explains how to create policies with user defined conditions in MS SQL 2008 using PowerShell scripts
2010-05-03
4,526 reads
TSQL Challenge 29 - Reorganize sales data by sales amount
Your job is to reorganize the items in the table by sales amount (quantity * price). Reorganize the items from left to right, bottom to top. The item with the highest sales amount should come on top left of each invoice.
2010-05-03
1,836 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Alamat Kantor BCA KCU Wisma Asia Telp:08218200174
Via Wa:628218200174 Alamat Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Alamat Kantor BCA KCU Kebayoran Baru Telp:08218200174
Via Wa:628218200174 Alamat. Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers