SQL Scripts Archives - Page 191 of 318 - SQL Authority with Pinal Dave

A DBA’s role is critical, because a production environment has to run 24×7, hence maintenance, trouble shooting, and quick resolutions are the need of the hour. The first baby step into any performance tuning exercise in SQL Server involves creating, analyzing, and maintaining indexes. Though we have learnt indexing concepts…

SQL SERVER – T-SQL Errors and Reactions – Demo – SQL in Sixty Seconds #005 – Video

March 7, 2012

We got tremendous response to video of Error and Reaction of SQL in Sixty Seconds #002. We all have idea how SQL Server reacts when it encounters T-SQL Error. Today Rick explains the same in quick seconds. After watching this I felt confident to answer talk about SQL Server’s reaction to…

SQL SERVER – Function: Is Function – SQL in Sixty Seconds #004 – Video

February 29, 2012

Today is February 29th. An unique date which we only get to observe once every four year. Year 2012 is leap year and SQL Server 2012 is also releasing this year. Yesterday I wrote an article where we have seen observed how using four different function we can create another…

SQL SERVER – Detecting Leap Year in T-SQL using SQL Server 2012 – IIF, EOMONTH and CONCAT Function

February 28, 2012

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

Note: Tomorrow is February 29th. This blog post is dedicated to coming tomorrow – a special day :) Subu: “How can I find leap year in using SQL Server 2012?“ Pinal: “Are you asking me how to year 2012 is leap year using T-SQL – search online and you will…

SQL SERVER – Identifying Guest User using Policy Based Management

February 27, 2012

SQL Tips and Tricks

Best Practices, Policy Management, SQL Scripts, SQL Server

If you are following my recent blog posts, you may have noticed that I’ve written a lot about Guest User in SQL Server. Here are all the blog posts which I have written on Policy Based Management subject. One of the requests I received was whether we could create a policy that would prevent users unable guest user in user databases. Well, here is a quick tutorial to answer this. Let us see how quickly we can do it.

SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB Database

February 24, 2012

SQL Scripts, SQL Server, SQL Server Security, System Database

SQL

I have written a few articles recently on the subject of guest account and MSDB Database. Here’s a quick list of these articles:

SQL SERVER – Disable Guest Account – Serious Security Issue
SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’ as the user is currently logged in.
SQL SERVER – Detecting guest User Permissions – guest User Access Status

SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video

February 22, 2012