TSQL Challenge 25 - Appointments and Recurring Schedules
The task is to look at the appointments and the recurrence of schedules to come up with a list of meetings for a given period.
2010-03-08
2,431 reads
Articles
Using Database Transactions across multiple SSIS Tasks
If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed. ...
2010-03-08
1,761 reads
SQL Server 2008 T-SQL Enhancements Part - I
SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes.
2010-03-05 (first published: 2009-01-22)
40,632 reads
Implementing User-Defined Hierarchies in SQL Server Analysis Services
To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on the database dimensions. Then you'll create the attribute relationships necessary to optimize performance. Analysis Services hierarchies offer plenty of possibilities for displaying the data that your business requires. Rob Sheldon continues his series on SQL Server Analysis Services 2008.
2010-03-05
2,953 reads
Mnesia: A Distributed DBMS Rooted in Concurrency
Find out what makes Mnesia, the Erlang-based database management system, perfect for distribution across a network of computers.
2010-03-05
2,974 reads
Should DBAs be Paid Overtime?
For the past several weeks, I have been running a poll on www.bradmcgehee.com, asking visitors if they thought that DBAs...
2010-03-05
2,783 reads
Calculating Moving Averages with T-SQL
How to efficiently calculate moving averages with SQL Server using Stock Market data.
2010-03-04
18,954 reads
Multiplatform ODBC support for SQLServer
The Microsoft SQL Server Connectivity team has a survey on the need for ODBC support for other platforms. If you use SQL Server from other platforms, let them know.
2010-03-04 (first published: 2010-02-25)
1,989 reads
2010-03-04
3,296 reads
Querying Oracle from Powershell Part 1
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
2010-03-04
2,943 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers