The licensing structure has evolved to reflect advances in technology and diverse use cases. Below are the primary licensing models available:
SQL SERVER – Find All The User Defined Functions (UDF) – Part 2
Few days ago, I wrote about SQL SERVER – Find All The User Defined Functions (UDF) in a Database. Regular reader of this blog Madhivanan has suggested following alternate method to do the same task of finding all the user defined functions in database. USE AdventureWorks GO SELECT specific_name,specific_schema FROM…
Read MoreSQLAuthority News – Download SQL Server 2017
This was a very old blog post and I have decided to re-write this as it was no longer useful. In this blog post, we will learn about SQL Server 2017. Here is how you can download SQL Server 2017 related material.
SQLAuthority New – SQL Server 2008 Books Online CTP (February 2008)
Download a Community Technology Preview (CTP) version of the documentation and tutorials for Microsoft SQL Server 2008. SQL Server 2008 Books Online CTP (February 2008) Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – UDF to Return a Calendar for Any Date for Any Year
It gives me great pleasure to write articles like today’s one because I have received great comment from one of regular reader who has taken UDF written by me and created another UDF using that UDF which enhances functionality of it. I had written previous article about SQL SERVER –…
Read MoreSQL SERVER – 2005 – FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: “A severe error occurred on the current command”
In SQL Server 2005 while testing Indexes I had created a table with one non clustered index only. I did not create any clustered index on table. After that I ran SELECT statement, it gave me following error. I was very surprised when I looked at error. It says Msg…
Read MoreSQLAuthority News – Download SQL Server 2008 February CTP (CTP 6)
SQL Server 2008 February CTP (CTP 6) has been released. Download from here. It will direct you to page which is dated November 2007. Continue with November 2007 which will take you to February 2008 CTP 6 Download page. Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.