On-Call Duties
What are some of the on-call duties a DBA must perform? TJay Belt talks about them in this new article.
2008-10-27
6,274 reads
Articles
Compare Dates
The following article shows how to compare dates in an iterative manner for a particular set of records in a single query
2008-10-27
4,953 reads
SQL Server Management Studio customized startup options
SQL Server Management Studio (SSMS) is now the primary tool that we all use to manage SQL Server. Whenever I open up SSMS I always go through the same steps to connect to a server and open certain query files. Are there any shortcuts or alternative ways of starting SSMS?
2008-10-27
4,716 reads
Data Trust
How much do you trust companies with your data? Steve Jones finds a couple new web sites that offer great services, but is it worth the price?
2008-10-26
70 reads
Data Trust
How much do you trust companies with your data? Steve Jones finds a couple new web sites that offer great services, but is it worth the price?
2008-10-26
66 reads
SSIS and Excel 2007
Longtime author Dinesh Asanka brings us a short tutorial on importing your data from Excel 2007 into a database using Integration Services.
2008-10-24
15,834 reads
Introduction to New T-SQL Programmability Features in SQL Server 2008
This paper introduces key new Transact-SQL programmability features in Microsoft SQL Server 2008 as well as SQL/Common Language Runtime (CLR) enhancements.
2008-10-24
6,178 reads
MSSQL Analysis Services - Attribute Member Names
Business Intelligence Architect Bill Pearson continues his exploration of Attribute Members, in another member of a subseries surrounding significant components of the Analysis Services dimensional model. In this article we examine the attribute member Name property, whose appropriate use is important to good model design and overall system performance.
2008-10-24
2,199 reads
Implementing Change Data Capture in Microsoft® SQL Server 2008
Change Data Capture is a new feature of SQL Server 2008 that can help you better handle your ETL systems. New author Suresh Yaram brings us an introduction to CDC and how it can be setup in your environment.
2008-10-23
10,507 reads
Parameterizing an Execute SQL Task - SQL School Video
In this SQL School video, MVP Brian Knight dives into the Execute SQL task in Integration Services. You will learn how to add parameters to this task to customize its behavior.
2008-10-23
3,930 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
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...
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