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
James Serra's Blog
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,334 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
667 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
557 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,270 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
788 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
557 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,642 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
726 reads
Welcome To Machine
Hello World. Stardate 1513.1. After reading that, if you know what I am referring to, you are a tech-head and...
2011-04-25
713 reads
Blogs
A New Word: Amoransia
By Steve Jones
amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for...
The Data API Builder Start and Add Extensions in VS Code
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Forums
DbDefence - how does work this tool?
How it is implemented? I have installed, tried, it is free for dbs <=30...
Technical Pain Behaviors
Comments posted to this topic are about the item Technical Pain Behaviors
trying to call powershell from TSQL statement
Hello, trying to call a powershell file I created, locally on the server, but...
Question of the Day
Counting Bits
What does the BIT_COUNT function do in SQL Server?
See possible answers