SQL Server Archives - Page 4 of 393 - SQL Authority with Pinal Dave

SQL SERVER – FIX: sp_rename error Msg 15225 – No item by the name of ‘%s’ could be found in the current database

January 5, 2016

Few days back I have written blog containing script for removing space in column name using sp_rename. In case you missed, I am listing them below for quick reference. SQL SERVER – Script: Remove Spaces in Column Name in All Tables SQL SERVER – How to Rename a Column Name…

SQL SERVER – Someone was trying to hack my SQL Server Logins in Azure!

January 4, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

When I started to work with SQL Server on Azure VMs, I was completely excited because now the need to build local VMs has become super easy. If I need something for testing, then I know I can get a SQL Server instance in a jiffy and it can be…

Interview Question of the Week #052 – Print String in Reverse Order

January 3, 2016

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Last week, I attended the last interview of the year. One of my co-interviewer asked a coding question to the candidate. In this type of question, the candidate is given one hour with SQL Server with a help file. The computer does not have internet candidate can use all the…

SQL SERVER – Script: Finding Cumulative IO Per Database File

January 2, 2016

Pinal Dave

SQL, SQL Server

MySQL, SQL Scripts

Sharing SQL Server related scripts is something I tend to do from time to time. At the SQLPass one of the attendees for my session around 42 tips asked, if I have any script that is handy to find the IO utilization per database file because they had couple of…

SQL SERVER – FIX: SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)

January 1, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages

Getting error and finding the cause is something which I like. And off late over the blogs I have shared a number of such incidents that have helped me figure out stuffs all by myself. Of course, I do my research and more often than not make things complicated because…

SQL SERVER – Are You Suffering from Unknown SSAS Performance Challenges? – Notes from the Field #109

December 31, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SSAS

[Note from Pinal]: This is a new episode of Notes from the Field series. We build our business application with zeal and enthusiasm. We believe it will do well for many years but it is not the case always. After a while performance started to go down and everything is not…

SQL SERVER – Unable to Start SQL Browser

December 29, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

My laptop is exposed to the internet and I have a passion to learn new software. Due to this, sometimes, I download some random software (unknowingly malware) on my machine and end up in infecting my laptop with a virus. These are never intentional. I think I have written earlier…