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 Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Following on from my previous post on building The Burrito Bot, I want to...
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers