ALTER SCHEMA TO ADD PERMISSIONS
I’m sure some of you have wanted to do this:
ALTER SCHEMA Steve AUTHORIZATION Steve
You realize this doesn’t work, and you...
2015-03-18
997 reads
24HOP Russian Edition
Spoke at 24HOP Russian edition.
Interesting experience.
It is difficult to determine mood of audience if there is no visible audience 🙂
And...
2015-03-18
590 reads
Women in Technology
Warning: rant forthcoming.
I don’t get the women in technology problem. Oh, I understand and see the problem. I also understand...
2015-03-18
474 reads
Women in Technology
Warning: rant forthcoming.
I don’t get the women in technology problem. Oh, I understand and see the problem. I also understand...
2015-03-27 (first published: 2015-03-18)
6,921 reads
Why not NOLOCK?
Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at...
2015-03-18
1,235 reads
Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month
Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm...
2015-03-17
553 reads
Excel Tip #21: Hiding Scrollbars in Excel Services Web Part
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-03-17
809 reads
T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable
Added few more examples
Prashanth Jayaram
On Technet forum, Op was looking for a way to get table cardinality for all databases...
2015-03-17
935 reads
Combating the CXPacket Wait Type
Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of...
2015-03-24 (first published: 2015-03-17)
7,465 reads
Increasing ColumnStore compression ratio for archival and “Cold storage”
At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This...
2015-03-17
362 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers