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
666 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
666 reads
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
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
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
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
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
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
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
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers