XML Workshop 25 - Inserting elements and attributes to an XML document
This article from MVP Jacob Sebastian looks at the modify method for changing an XML document.
Leaving a SQL Server DBA Job Gracefully
You’re leaving your current employer for a new opportunity and want to make the move as smooth as possible. You don’t want to burn your bridges and want to make sure that everything you’ve left behind can be managed by the people you’ve left behind or the DBA who is replacing you. So, you’ve done your handover documentation and trained up the new guy. You definitely don’t want to be that DBA who is cursed the week after they leave when their network account is disabled and a bunch of stuff ‘breaks’.
Scripting database objects in SQL Server 2008
In this article, we would go through the
steps to script the objects in a database using SQL Server 2008....
An Urgent Ad Hoc Report
In this new article, Yakov Shlafman shows us how he wrote a quick ad hoc report of expenses so that he could leave on time one day.
Security Regulations
There have been calls for governmental security regulations for IT. Is that a good thing? Steve Jones comments today.
Finding Date Ranges for Calculating Statistics
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
SQL Saturday #41 - Register and Call for Speakers
If you'll be near Atlanta on Apr 24, 2010, come to SQL Saturday #41. If you are at all interested in speaking, submit a session.
Professional Microsoft SQL Server 2008 Programming - Sample Chapter
Professional Microsoft SQL Server 2008 Programming Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical […]
Stop, Don't Panic
Your response in a crisis situation can be critical to how quickly you solve the issue. Steve Jones reminds you to stay calm in today's editorial.
T-SQL: Why “It Depends”
Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers