SQL Rally: Don’t Vote for My Sessions
So I found out on Friday that I am going to be a speaker at the Dallas SQL Rally, which...
2012-02-20
466 reads
Blog Posts
SQL Server – Powershell Active Directory search
Working with Powershell and Active Directory simplifies some complex tasks for the DBA.
Active Directory is LDAP compliant. This means the...
2012-02-20
1,278 reads
SQL Server 2012 (“Denali”): PowerPivot
Version 2 of PowerPivot (download) is being made available with SQL Server 2012. There are many new features, and my top 5 are:
Diagram...
2012-02-20
1,542 reads
SSRS – Creating a Reporting Services Web Farm
Reporting Services performance problems can often be narrowed down to report design or resource constraints and sometimes a combination of...
2012-02-20
3,980 reads
SSRS – Embedding Refreshable Reports in Office Tools
Have you ever experienced this?
You have developed a set of Reporting Services report that your users love and they often...
2012-02-20 (first published: 2012-02-14)
2,698 reads
Will You Sponsor the #SQLPlunge?
At the beginning of next month, a few hearty souls have decided that they’d like to do a little to...
2012-02-20
560 reads
Cartesian/Cross Join
I was once asked in a job interview if I knew what a Cartesian/Cross Join was.
A more interesting question is:...
2012-02-19
2,730 reads
How can I configure SQL Server to listen on multiple TCP/IP ports?
Run the SQL Server Configuration Manager, expand SQL Server Network Configuration and select the protocols for appropriate instance. Double click...
2012-02-18
10,200 reads
SQL Server Isolation Levels By Example
Isolation levels in SQL Server control the way locking works between transactions.
SQL Server 2008 supports the following isolation levels
Read Uncommitted...
2012-02-18
507 reads
SQLMidlands & SQLLunch
Many thanks to all those that turned out to see my presentation on Thursday (16th of Feb) of “Cursors are...
2012-02-18
756 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers