A customer provides an SQL Server Analysis Services trace file to analyze. You save this file into a trace table and execute T-SQL code to analyze the results. Rather than getting descriptive values for the EventClass and EventSubclass data, you get numerical values. How do you resolve these numerical values to meaningful descriptive names? Check out this tip to learn more.
You’re desperately trying to get things done but it’s just not happening for you. I’m going to let you in on a little secret, you’re doing it wrong!
Describes the gains experienced in my environment by implementing AWE.
The definition of Big Data is rather murky, despite all the press and attention given to it. Steve Jones talks about what Big Data means for relational databases.
Arshad Ali discusses the details of creating reports with indicators and gauges in SQL Server 2008 and walks you through designing a one tablix report with two levels of grouping.
Self service in IT is something Steve Jones likes, but it doesn't solve all problems, and might end up creating more issues.
Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup.
On Thursday May 17th 12PM noon Central, Mike Fal will discuss "SQL Server's table partitioning gives the DBA tools to manage this beast and support very large tables in a way where index management and data retrieval..."
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
Phil Factor welcomes SQL Server support by Amazon RDS, as an alternative to having Microsoft as service provider as well as software provider, via the PaaS formerly known as Azure.
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers