Search Active Directory (AD) from your desktop
Ever see a Windows group and want to know all the users in that group without having to ask your...
2011-05-27
705 reads
Ever see a Windows group and want to know all the users in that group without having to ask your...
2011-05-27
705 reads
If you have been in the IT field for any length of time, I’m sure you have heard the phrase...
2011-05-25
1,549 reads
When using role security in SSAS, one point of confusion is when a person sees the grand total for a...
2011-05-23
882 reads
When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up...
2011-05-20
1,037 reads
Interesting new BI site from Microsoft called “BI Labs“. This site says: “BI Labs is a collection of experimental business...
2011-05-18
1,131 reads
While there are many DBA’s who do business intelligence, or BI, I believe there are even more who do not. ...
2011-05-16
1,193 reads
Every couple of weeks I see this SSAS error when processing one of my cubes:
Internal error: Invalid enumeration value. Please call...
2011-05-13
1,472 reads
A quick tip for you: Ever get some SQL or MDX sent to you in an email, or copied from a...
2011-05-11
695 reads
A quick little tip I found a couple of years ago. Ever use the count(*) syntax and it takes forever...
2011-05-09
587 reads
There are three job boards that I use: Dice, Monster, and LinkedIn. I prefer Dice by far, since it has...
2011-05-06
1,304 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers