Adding Column to a SQL Server Table
This article examines the difference between adding a nullable column to a table or a column with a default value.
2011-04-27
5,393 reads
Articles
Performance Troubleshooting with Windows Resource Monitor - Part 2
In the second part of the Resource Monitor series we conclude with a look using the Memory tab and Disk tab to diagnose performance issues.
2011-04-26
4,198 reads
How to Setup Report Parameters to Default Based On User Credentials
This article explains how to setup Reporting Services (SSRS) parameters default values using user credentials.
2011-04-25
15,495 reads
Backup and Restore of an Analysis Services Database
One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user and system databases. In this article we will take a look at the steps which a database administrator needs to follow to backup and restore an analysis services database.
2011-04-25
3,172 reads
SQL Server 2008 R2 Service Pack 1 Customer Technology Preview Available
You can help test the first service pack for SQL Server 2008 R2 and ensure the highest quality possible for its release.
2011-04-25
2,610 reads
ShowPlan Operator of the Week - Split, Sort, Collapse
'Split, Sort & Collapse' is, happily, not a description of the intrepid Fabiano Amorim after his epic series of articles about the ShowPlan operators. With renewed stamina, Fabiano continues his mission to describe all the major operators by explaining the Trivial Plan and the power of unique indices.
2011-04-22
3,882 reads
SQL Server Webinar Series #9: Streamlining SharePoint Recovery
Metalogix Selective Restore Manager streamlines the process of finding and recovering individual documents and lists directly from a SharePoint content database backup file without the need for a recovery farm. When used in conjunction with Red Gate’s SQL Virtual Restore, Selective Restore Manager can recover documents and lists without physically restoring the backup file—saving time and much needed disk space. Together, Metalogix Selective Restore Manager and Red Gate SQL Virtual Restore open up new possibilities for your SharePoint backup and recovery strategy. Apr 21, 2011, 11am EST.
2011-04-21 (first published: 2011-04-12)
3,293 reads
When does a Tumbling Window Start in StreamInsight
Whilst getting some courseware ready I was playing around writing some code and I decided to very simply show when a window starts and ends based on you asking for a TumblingWindow of n time units in StreamInsight. I thought this was going to be a two second thing but what I found was something I haven’t yet found documented anywhere until now.
2011-04-21
2,346 reads
Database Normalization Webcast
Join Normalization nut Thomas LeBlanc for a review of a standard operating procedure used among DBAs at an employer. See the changes he made after joining the BI group at this employer. The session will go through naming conventions, check list for creating a table, formatting in stored procedures, and more. A brief preview of the SQLRally talk 3rd Normal Form: That’s Crazy Talk!!! Will be given about Lookup tables. Thur, Apr 21, 2011, 12:00pm EST.
2011-04-20
2,723 reads
Implementing Database Settings Using Policy Based Management
This article demonstrates how a DBA can check for policy compliance by leveraging the Policy Based Management Feature of SQL Server.
2011-04-20
2,820 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
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