Learning about practical Integration Services is an important part of the well rounded DBA for the future. Read a sample chapter from this new book.
2010-03-23
2,316 reads
How to reverse engineer or script a trace for disaster recovery, or simply scripting for enhance and adjustment.
2010-03-23
2,045 reads
Yesterday was the first day of the SQL Server 2008 R2 airlift.I attended a great session on Implementing a Fast...
2010-03-23
972 reads
One of the most useful new features of SQL 2008 R2 for DBA’s is the ability to manage and administer multiple instances of SQL Server from a central location using the new SQL Server Utility tool.
2010-03-23
2,110 reads
Wouldn't it be nice if you could have the report's name and filename be changed to something more specifically related to the particular run of that report.
2010-03-22
34,446 reads
I have installed SQL Server 2008 Developer Edition on Windows Server 2008 R2 and I am unable to get connect to SQL Server 2008 Instance from SQL Server 2008 Management Studio which is installed on another remote server. As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 in Windows Firewall for user connectivity.
2010-03-22
3,074 reads
Here is another scheduling problem that deals with the allotment of classrooms for various training programs. Your chalenge is to read the source data and build an output result set that shows the weekly schedule of each training topic and the class room in which training is scheduled.
2010-03-22
1,783 reads
Continuing with his series on T-SQL enhancements in SQL Server 2008, Arshad Ali brings us a look at the HierarchyID and Large UDTs.
2010-03-19 (first published: 2009-08-27)
25,193 reads
You can also identify I/O bottlenecks by examining the latch waits. These latch waits account for the physical I/O waits...
2010-03-19
2,337 reads
Martin Policht delves deeper into the specifics of SQL Server 2008 and 2008 R2's Integration Services by presenting the most straightforward method of creating SSIS packages using Import and Export Wizard.
2010-03-19
4,663 reads
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
I’ve been doing storage load tests for SQL Server for a long time, both...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Comments posted to this topic are about the item Half of All Engineers
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers