SQL Server Grouping Workbench
Robyn Page and Phil Factor take on GROUP BY queries in SQL server, starting on the nursery slopes but finishing with a wild ride off-piste.
2007-05-18
2,426 reads
Additional Articles
SQL Server 2005 Integration Services - Part 48
Maintenance Plan Designer gives you access to 11 tasks, which allow you to perform a variety of database management activities. This article provides a brief overview of each of them, focusing on their recent improvements.
2007-05-17
2,903 reads
Returning a week number for any given date and starting fiscal month
Sql Server comes with a host of built in functions such as ISNULL, CONVERT and CAST. Now if that wasn't enough rope to hang ourselves with, as of Sql Server 2000 we gained the ability to create our own user defined functions. In this article I will be looking at the three main date functions DATEADD, DATEPART and DATEDIFF (there is a fourth called DATENAME but I want to get to the end of this article before you fall asleep so I decided to leave it for another date and time! And no it doesn't foretell the name of your future blind date so it's not as interesting as it sounds anyway) Then I will be combining all three in a user defined function of our own by which time our necks will be well and truly stretched
2007-05-15
2,831 reads
XML Restructuring and Reshaping Should Not be Considered the Same
Michael M. David returns to SQLSummit.com to explore two approaches to XML hierarchical structure transformations. He explains the difference between restructuring and reshaping XML data, with the latter driven by the semantics of the data structure.
2007-05-14
1,954 reads
Fired With Enthusiasm
Phil Factor's describes his first encounter with the "light arms" (low calibre, small bore, needed to be fired).
2007-05-11
3,478 reads
Using SQL 2005 with Expression Web
his article will explore various methods of accessing SQL Server from inside Microsoft Expression Web. Microsoft Expression Web is a graphical development tool for creating web pages and is part of the new Expression Studio.
2007-05-10
2,274 reads
Use SqlBulkCopy to Quickly Load Data from your Client to SQL Server
The .NET Framework 2.0 introduces a very handy new class in the System.Data.SqlClient namespace called SqlBulkCopy that makes it very easy and efficient to copy large amounts of data from your .NET applications to a SQL Server database. You can even use this class to write a short .NET application that can serve as a "middleman" to move data between database servers.
2007-05-09
3,525 reads
Alert-based Transaction Log Backups using SMO
Allen White provides an SMO script for automating database log backups, using either native backup or Red Gate's SQL Backup tool.
2007-05-07
2,426 reads
SSIS Configurations
In this session, Brian shows you how to use configuration files or a configuration file to dynamically configure your packages. With configuration files, you can seamlessly migrate an SSIS package from QA to production without worry and without having to reconfigure the package.
2007-05-04
2,582 reads
SSIS Control Flow Basics
In this session, Brian shows you the basics of the SQL Server Integration Services Control Flow. He shows you how to orchestrate a package in the control flow with precedence constraints and how they relate tasks together in the control flow and how to tasks are executed and in what order. He also shows some of the advanced properties of the control flow that help with parallelism.
2007-05-03
2,533 reads
Blogs
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers