Creative SPAM
SPAM permeates all aspects of our lives. Steve Jones takes a poll today about which messages might have caught your eye.
Creative SPAM
SPAM permeates all aspects of our lives. Steve Jones takes a poll today about which messages might have caught your eye.
Exploring SQL 2005’s Ranking Functions – NTILE() and ROW_NUMBER()
Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.
Operations Manager: A Big Tinker Set
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set.
Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
Build Great Looking Excel Spreadsheets
Exporting data from your database and building reports is easy with Reporting Services, but sometimes you need to use other sources
SQL Server User Group in Luxembourg
A new SQL Server user group is starting up in Luxembourg. Be sure you read this if you are in the area and want to participate.
SQL Server Schema Binding and Indexed Views
How do you handle this error? "Cannot create index on view, because the view is not schema bound".
Super Sizing Columns in SQL Server
This article describes how to work with large objects in SQL Server using the MAX Specifier
Testing Service Pack 3
Who is responsible for Service Pack testing? Ultimately it's Microsoft, but Steve Jones reminds us we make a difference as well.
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