Join BI Architect Bill Pearson as he continues his overview of Attribute Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.
This article describes different ways of improving the performance of SQL Server queries, with a focus on index optimization.
When writing SQL, picking good tables aliases can greatly enhance the readability of your code
This module, part 2 of the online training course "Becoming a Profiler Master", discusses the inner workings of Profiler.
How do you protect and monitor your databases? Auditing is one way, but Steve Jones thinks this subsystem in SQL Server needs to mature.
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
Now, Internet-hosted distributed applications with connectivity to internal applications—often referred as Software plus Services (S+S)—are gaining popularity. Organizations are leveraging datacenters hosted by third parties to alleviate concerns about hardware, software, reliability, and scalability. These are just some of the new architecture trends that help you build interoperable applications that scale, reduce capital expenditure, and improve reliability. Cloud computing offers many of these benefits.
To scale your SQL Server properly means to make it bigger and better. But what is the best method for 2008?
By Steve Jones
Houston AI-Lytics 2026–Powerpoint Slides Thanks to everyone for attending my session on running a...
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Comments posted to this topic are about the item Let's Talk Community Events!
Hi as shown below a replication target requires a primary key. if we want...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers