Tags » SQL Server

Large MSDB Database From sysmaintplan_logdetail Table

— By Lori Brown  @SQLSupahStah

I recently received a panicked call from a client who had a SQL instance go down because the server’s C drive was full. 446 more words

SQL Server

SQL Server Infernals - Circle 3: Shaky Typers

Choosing the right data type for your columns is first of all a design decision that has tremendous impact on the correctness of the database schema. 1,235 more words

SQL Server

SQL Trigger to find who updated a table and when it was done

I had a situation to find who is updating a table and when the table is getting updated but it was very difficult to enable trace for a long time. 112 more words

SQL

FOR JSON Clause With PATH Mode In SQL Server 2016

In previous blog we learnt about changing query format using JSON clause with AUTO mode option. In this blog we will learn formatting of query output using FOR JSON clause with PATH mode in SQL Server 2016. 208 more words

Sql Server

SQL SERVER - Why Haven’t You Disabled CPU Power Saving Yet?! - Notes from the Field #087

: This is an 87th episode of Notes from the Field series. Every week, I personally wait for the notes from the fields from Mike because it contains lessons of life which directly impacts DBA and Developer’s life positively. 723 more words

SQL Authority

Power BI Hands-On Workshop at PASS Global Summit

Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop.

Bring your laptop and let’s build a real business intelligence (BI) solution using Power BI! 126 more words

SQL Syndication

How to Grant limited permissions to create views in another schema?

How to Grant limited permissions to create views in another schema?

In SQL Server 2005 and 2008R2 you can grant permissions at the schema level and, in fact, this is what you’ll need to do to give them the ability to create the views.  463 more words

SQL Server