I've had a few requests in the past, so I decided to just give it a go. Here's the raw footage from the episode of the Voice of the DBA podcast that I shot this week. It's uncut, the raw footage of what I took off the camcorder,
2009-07-17
940 reads
Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.
2009-07-16
5,924 reads
This edition of SQL School brings us a look at how to set single user mode for your SQL Server instance.
2009-07-16
4,215 reads
I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members. Though the story was specific to database professionals, the same principles apply to almost any hiring situation. The moral of Brent’s story...
2009-07-16
1,541 reads
This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?
2009-07-16
658 reads
This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?
2009-07-16
914 reads
We have heard that you can create filters in a Performance Point dashboard then apply them to one or more reports and scorecards. Can you provide some step-by-step instruction on how to do this?
2009-07-16
2,102 reads
MSAS Architect Bill Pearson leads the hands-on creation of an exploded pie chart based upon an Analysis Service data source.
2009-07-16
2,446 reads
In this article sponsored by Red Gate, read about a beta tester's experience with new versions of SQL tools.
2009-07-16
1,595 reads
This post shows you how to download files from a web site whilst really making the most of the SSIS objects that are available. There is no task to do this, so we have to use the Script Task and some simple VB.NET or C# (if you have SQL Server 2008) code
2009-07-15
2,999 reads
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers