Responsibility to Learn
“I would educate myself, and that I would never stop educating myself. It was my responsibility to keep learning.” Who said that? Albert Einstein? Da Vinci? Stephen Hawking? None of the above. That statement came from the Demon of the rock band KISS, Gene Simmons. If a rock & roll legend knows that it’s on […]
Is It Time To Stop Using IsNumeric()?
The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to.
Analysing Sales Patterns: R + SQL Server
We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.
Is a Temporary Table Really Necessary?
In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.
Reporting Services Makes Server Support Easier
Reporting Services is one of the most widely used subsystems in SQL Server and there have been some very creative solutions invented by DBAs around the world. New author Carolyn Richardson is one of those, bringing us a implementation that tracks uptime and disk space for her SQL Servers
Understanding the difference between IS NULL and = NULL
This article by James Travis details the differences between IS NULL and = NULL. He also discusses the ANSI_NULLS setting.
Database Code Analysis
Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.
Opinions and Votes
When we look to improve software, we are often expressing our opinion on which items need to be handled first. It's helpful to keep in mind that it's an opinion being expressed, and not a vote, no matter how much it is solicited by a company.
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
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...
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