Is it 1995?
A bug in the SQL Server 2008 upgrade process has Steve Jones questioning the coding practices at Microsoft.
2008-09-13
491 reads
Articles
Is it 1995?
A bug in the SQL Server 2008 upgrade process has Steve Jones questioning the coding practices at Microsoft.
2008-09-13
719 reads
Is it 1995?
A bug in the SQL Server 2008 upgrade process has Steve Jones questioning the coding practices at Microsoft.
2008-09-13
760 reads
Attribute Member Keys – Pt 1: Introduction and Simple Keys
Join Business Intelligence Architect Bill Pearson as he kicks off an exploration of Attribute Member Keys, a continuation of a body of articles surrounding significant components of the Analysis Services dimensional model. In this article we introduce Attribute Member Keys, focusing upon the simple keys and their properties.
2008-09-12
2,459 reads
Best Practices for Data Warehousing with SQL Server 2008
There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices, which are presented with particular reference to the features in SQL Server 2008.
2008-09-12
5,318 reads
2008-09-11
66 reads
Creating a Tabular Report - SQL School Video
SQL School continues with our series on Reporting services, this time examining how tabular reports can be easily built.
2008-09-11
4,891 reads
Patindex
This artcle by new author Manie Verster examines the use of the PATINDEX function in T-SQL.
2008-09-11
10,467 reads
Automatically Running Stored Procedures at SQL Server Startup
I have a stored procedure I want to run when SQL Server starts. Is there a way to execute this procedure automatically each time the SQL Server service is started?
2008-09-11
3,855 reads
Hands-on SQL Server from SQLSkills
In San Francisco, Kimberly Tripp and Paul Randal of SQLSkills will be presenting a two and a half day, hands-on workshop covering database infrastructure and scalability.
2008-09-11
2,440 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers