Like most everyone who works hard in our industry, I’ve run into more than a few conflicts trying to balance work and life. Personally, the further I progress in my career, the blurrier the lines become between work time, family/me time, and just plain lazy downtime. It’s quite easy to say that you’re going to spend X hours at work, and the rest of the time is mine, but the reality is ...
2009-03-06
1,308 reads
This article shows how Microsoft Office Visio 2007 can be used to visualize cube data created using SSAS
2009-03-06
2,488 reads
A new SQL Server user's group in Iowa is having a meeting next week.
2009-03-05
273 reads
ln this SQL School video, learn how you can format the various measures in your SSAS cubes.
2009-03-05
3,727 reads
Yesterday I blogged about how to figure out what database principals corresponded to what server principals . The key is to match up the SIDs between sys.server_principals and sys.database_principals. But I also stated there were 3 cases where the logins...
2009-03-05
2,928 reads
I have heard that there is a new version of Report Builder in SQL Server 2008. Can you provide some details and examples?
2009-03-05
4,254 reads
SSAS Architect Bill Pearson examines another intrinsic member property, LEVEL_UNIQUE_NAME, which allows us to exercise a great deal of presentation “sleight of hand” in working with MDX in Analysis Services, as well as within Reporting Services and various other reporting applications that can access an Analysis Services cube.
2009-03-05
1,511 reads
IT is an industry that hasn't adopted a union, at least not yet. Many IT workers hope it never happens, but what if it does? This Friday Steve Jones asks what benefits you might want from a union.
2009-03-05
609 reads
IT is an industry that hasn't adopted a union, at least not yet. Many IT workers hope it never happens, but what if it does? This Friday Steve Jones asks what benefits you might want from a union.
2009-03-05
649 reads
IT is an industry that hasn't adopted a union, at least not yet. Many IT workers hope it never happens, but what if it does? This Friday Steve Jones asks what benefits you might want from a union.
2009-03-05
889 reads
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...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
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