Guide to MCITP: SQL Server 2008 BI Developer
A guide to the SQL Server 2008 Business Intelligence exams.
2012-05-11
12,405 reads
Articles
The T-SQL of CSV: Comma-Delimited of Errors
Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewhat magical. Just to prove it is possible, Phil Factor creates a CSV version of AdventureWorks as a linked server.
2012-05-11
5,604 reads
Performance Test of New Date Manipulation Functions (SQL Spackle)
Performance test of new SQL 2012 functions DateTimeFromParts and Format
2012-05-10
6,200 reads
Export data to an earlier SQL Server version
I have data in a SQL Server database that I need to get to an older version of SQL Server. I tried the backup and restore method, but received an error indicating that this wasn't allowed. I also tried to detach and attach the database, but that operation failed too. I understand that typical methods I use to move the database around don't work when I have to work with an earlier SQL Server version. What can I do to get the data out? This is a simple database and I want to spend a minimal amount of effort.
2012-05-10
3,518 reads
Setup SQL Server on Amazon RDS
Learn how you can set up a new SQL Server instance painlessly on Amazon's Relational Database Service (RDS)
2012-05-09
5,301 reads
Transaction Replication Latency Diagnosis
Identify resource bottlenecks in a stressed transaction replication topology using PERFMON/PAL and system wait stats
2012-05-09
2,641 reads
How to Create an Indicator and Gauge Report in SSRS
SQL Server Reporting Services provides several ways to analyze the data; a few of them are creating reports with indicators and Gauges. Indicators are minimal gauges that convey the state of a single data value at a glance and are mostly used to represent the state value of Key Performance Indicator (KPI, a measurable value which has business significance with a specific target or goal that indicates whether things are going good or bad).
2012-05-09
3,573 reads
Deciding between COALESCE and ISNULL in SQL Server
When writing T-SQL, a lot of developers use either COALESCE or ISNULL in order to provide a default value in cases where the input is NULL. The two functions do have quite different behavior and it is important to understand the qualitative differences between them when using them in your code.
2012-05-08
9,869 reads
An examination of bulk-logged recovery model
This article looks at the bulk-logged recovery model in depth and examines how it affects disaster recovery and logging.
2012-05-07
7,229 reads
Big Data is Just a Fad
The Term 'Big Data' is nothing more than a fad, and we'll soon be cringing with embarrassment at the thought that we ever used it. However, the data, and the challenges to processing it that it presents, will stay with us. If jargon like 'Big Data' helps us focus on the problems, then let’s use it: temporarily, perhaps.
2012-05-07
3,718 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