What is SQL PASS?
A few weeks ago I asked a colleague, who is a DBA, if he was going to the SQL PASS...
2011-11-04
1,100 reads
James Serra's Blog
Salaried employee vs contractor
Are you a salaried employee looking to switch to a W-2 or 1099 contractor? (For an explanation of W-2 and...
2011-11-02
4,111 reads
Miss SQLBits 9? No problem, all videos are online
All the videos for this popular conference are online or will be soon (48 of them). Take a look at the...
2011-10-31
2,264 reads
SQL Server Analysis Services Performance Guide published
Another must read white-paper: Analysis Services 2008 R2 Performance Guide.
This white paper describes how business intelligence developers can apply query...
2011-10-28
2,516 reads
Miss TechEd Australia 2011? No problem, all videos are online
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the...
2011-10-26
849 reads
What is Microsoft TAP and RDP?
Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product...
2011-10-24
2,231 reads
SSIS – Can’t Enable/Disable within Data Flow Tab
This is my biggest gripe with SSIS: I have a data flow task, and within that I’m pulling data from...
2011-10-21
3,023 reads
Microsoft and HP’s Database Consolidation Appliance
Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (see my blog about the other two appliances). ...
2011-10-19
1,770 reads
Performance tips for SSAS
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,125 reads
Formula engine and storage engine in SSAS
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. ...
2011-10-14
1,208 reads
Blogs
A Win in the Fight Against Cyber Scams
By Brian Kelley
Back in June I blogged about pig butchering and the amount of reported losses...
SQL Server I/O Bottlenecks: It’s Not Always the Disk’s Fault
By Kevin3NF
“SQL Server is slow.” We’ve all heard it. But that doesn’t always mean SQL...
Just a few weeks to PASS on Tour and the Redgate Summit
By Steve Jones
It’s just a few weeks until the PASS Summit on Tour in New York...
Forums
What the best ways to create an AG and do failovers with 8TB databases?
Hello. I've been working with AGs for a few years now. However, in my...
Deprecated but Forgotten: Why SQL Server’s Text, NText, and Image Data Types Still Haunt Your Systems
Comments posted to this topic are about the item Deprecated but Forgotten: Why SQL...
Why CQRS and Event Sourcing Are Gaining Ground in High-Concurrency Web Systems
Comments posted to this topic are about the item Why CQRS and Event Sourcing...
Question of the Day
Page Compression, Unique Identifiers and Speed
Would using a UNIQUEIDENTIFIER as a clustered primary key improves page compression and speeds up inserts compared to INT IDENTITY?