New Microsoft BI Labs site
Interesting new BI site from Microsoft called “BI Labs“. This site says: “BI Labs is a collection of experimental business...
2011-05-18
1,113 reads
James Serra's Blog
DBA’s, want to earn the big bucks? Learn BI
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,161 reads
SSAS error when processing the cube
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,378 reads
Dirty looking SQL or MDX? Clean it up
A quick tip for you: Ever get some SQL or MDX sent to you in an email, or copied from a...
2011-05-11
670 reads
A quicker way than using count(*)
A quick little tip I found a couple of years ago. Ever use the count(*) syntax and it takes forever...
2011-05-09
560 reads
The best IT job boards
There are three job boards that I use: Dice, Monster, and LinkedIn. I prefer Dice by far, since it has...
2011-05-06
1,272 reads
SSIS package runs fine until put in a job
I see this issue pop up every now and then: A developer creates an SSIS package in BIDS and gets...
2011-05-04
790 reads
What to blog about?
As I mentioned in my first post, I thought it would be real difficult to think of things to blog...
2011-05-02
558 reads
Antivirus solutions that are free
So my sister called me the other day to tell me she has a message on her laptop that said...
2011-04-29
1,645 reads
What name should I call myself?
In creating this blog, I was thinking about using some catchy name for myself. Something with “DBA” in it. However,...
2011-04-27
729 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
extended events to spy on our server between 8 and 9 am
Hi, our peer who owns a remote mysql server from which we extract warehouse...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers