Limiting Table Access for Reporting Part 2
Blog Title: Limiting Table Access for Reporting Part 2
In the first blog post of this series, I showed you how...
2010-07-29
568 reads
Blog Posts
Log Shipping By Abi Chapagai (Revised)
Log Shipping By Abi Chapagai (Revised)
In SQL Server, transaction log provides an ability to recover a database to a point...
2010-07-29
2,385 reads
Pesky Protected Mode
How many of you keep falling for this one…You open up Report Manager for a user that you know you...
2010-07-29
1,473 reads
Poor Little Misunderstood Views
Some people love ‘em, some people hate ‘em. But, one thing I have found to be nearly universal is that...
2010-07-29
59,911 reads
Schedule Published for SQLSaturday #51 in Nashville
Just released, http://www.sqlsaturday.com/51/schedule.aspx?sat=51. Five tracks, lots of good speakers, but I see a few new names too. Looks like a...
2010-07-29
1,373 reads
SQL Bits 7 – Registration is Open !
Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!
This year its in York (Sept 30th till October 2nd).
SQLBits is...
2010-07-29
1,484 reads
SQL Saturday Advice - Communicate Often
It seems that Thursdays are becoming SQL Saturday day here at my blog. I wrote a few posts about SQL...
2010-07-29
1,109 reads
SQLSaturday #40 is Almost Here – July 31, 2010
I’ll be leaving Friday morning with my family to go to Miramar, Fla, for the 2nd annual SQLSaturday there. I’m...
2010-07-29
528 reads
The Dangers of Sub-queries!!!!
Ok, now that I have your attention this really should be titled the danger of not qualifying all objects, but...
2010-07-29
738 reads
The Killer Backslash in TSQL
--it is
quite startling to see that this, in TSQL, executes.
Select \
/*
---------------------
0.00
(1
row(s) affected)
so does
this....
*/
Select null /\/\/\/\/\/\/\/\/\/\/\/\
/*
---------------------
NULL
(1
row(s) affected)...
2010-07-29
5,817 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers