SQL Server consolidation strategies and best practices
Learn about the benefits of SQL Server 2008 consolidation on Windows 2008, with details on the different consolidation strategies available to organizations.
2009-04-07
2,707 reads
Additional Articles
SQL Server UDF to convert integer date to datetime format
This short tip shows how you can convert an integer date, such as those stored in msdb to a real datetime value.
2009-04-03
3,612 reads
Automatic Full Parallel Processing of Hierarchical SQL Queries
Although adding multiprocessing capabilities to applications is labor-intensive and error-prone, adding multicore capability to SQL query processing can be automatic, benefiting huge numbers of applications with little developer effort.
2009-04-02
2,311 reads
Service Broker Poison Message Handling
Recent installments of our series dedicated to SQL Server 2005 Express Edition have focused on error handling techniques that leverage Service Broker's transactional nature. This article describes Poison Message detection characteristics and presents an example demonstrating its use.
2009-04-02
1,585 reads
The Concept of Cardinal Reciprocity- A Primer
Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a number of subtle problems with database design in terms of its derivability, redundancy, and consistency. . Increasingly, this little-understood aspect of relational theory, that emphasises the cardinality of the attributes of tuples in a relation and the reciprocity with isomorphic foreign key restraints, is becoming a hot forum topic.
2009-04-01
2,846 reads
How to Identify Blocking Problems with SQL Profiler
Many SQL Server developers and DBAs have, in the past, had their own favourite diagnostic Stored Procedures for investigating blocking issues. But since SQL Server 2005, it's a good idea to use the SQL Profiler for all but the most complex problems. Brad McGehee takes us through the steps...
2009-03-31
3,761 reads
Monitoring SQL Server Agent with Powershell
This article introduces the reader to Powershell. The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running.
2009-03-31
3,061 reads
Connecting Oracle BI Publisher to SQL Server
One of the main features of Oracle Business Intelligence Publisher (BIP) is its ability to connect to pretty much every major RDBMS on the market. Steve Callan shares the little documented steps of how to establish a connection to SQL Server.
2009-03-30
1,937 reads
Dropping multiple objects with a single DROP statement
Most SQL Server users drop one object at a time using either SSMS or a single drop statement. In many scenarios we may need to drop several objects of the same type. Is there a way to drop several objects through less lines of code?
2009-03-30
4,719 reads
SQL Q & A: Database Consistency, Temporary Tables, and More
Why does DBCC CHECKDB find corruption errors that disappear? Does tempdb really cause performance issues? Are there any drawbacks to using the FILESTREAM datatype? Paul Randal answers these reader questions and more.
2009-03-27
4,251 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Niaga Grisenda TLP/WA 08218573837
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Komplek, Ruko Niaga Grisenda, Jl. Pantai Indah Kapuk Jl. Kapuk Raya No.19-20 Blok GE,...
BCA KCP Iskandar Muda TLP/WA 08216977701
Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec. Kebayoran Lama, Kota...
BCA KCP Percetakan Negara HUB/WA 08216977701
Jl. Percetakan Negara No.223 C, Rawasari, Kec. Cemp. Putih, Kota Jakarta Pusat, Daerah Khusus...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers