Expanding The Scope of Bridge Tables
Timothy Claason continues talking about database design in a new article. This one talks about expanding the functionality that Bridge Tables provide in your schema.
2010-03-23
8,259 reads
Articles
Microsoft SQL Server 2008 Integration Services Problem-Design-Solution - Sample Chapter
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,317 reads
Reverse Engineering a Server Side Trace
How to reverse engineer or script a trace for disaster recovery, or simply scripting for enhance and adjustment.
2010-03-23
2,060 reads
Minimizing Fragmentation when Moving data using a Switch
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
SQL Server 2008 R2 Multi-server Administration - A First Look
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
Dynamically name report/file export in SSRS
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,631 reads
Configure Windows Firewall for SQL Server 2008 Database Engine in Windows Server 2008 R2
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
TSQL Challenge 26 - Identify weekly schedule of training programs by course, classroom and timing
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
SQL Server 2008 T-SQL Enhancements Part - III
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,212 reads
Microsoft SQL Server identify I/O bottlenecks
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
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