(JackLi) A user called in for help because he wasn’t able to drop a user from a database. The error message is below

(John Miner) For any given postal address, determine the time zone information used by the people that work and live there.

(Pinal Dave) I have been writing on various ways of working with PowerShell and how to connect to SQL Server. Personally, when I see text on command prompt it is quite a mess and very difficult to decipher the same. If you play around and look at various blog posts, they show some interesting output

(Siddharth Mehta) You need to create project files for a SQL Server Analysis Services (SSAS) tabular database deployed on a SSAS Tabular Instance, but you don’t have access to the project source for some reason. Creating an entire project from scratch that reflects the deployed database is not an op

(Pinal Dave) Working with powershell scripts can be interesting. I have in the past shown a number of such scripts that we can use with SQL Server. In this blog, I was playing around understanding how I can use the get-process commandlet and how it can be used with SQL Server.

(Ahmad Yaseen) Statistics are small objects that describe the data distribution for tables and indexes in a SQL Server database. These statistics are used by the SQL Server Query Optimizer to determine the best plan to execute a query. Because of this importance, these statistics should be up to dat

(Vinoth N Manoharan) My Client recently complained that his linked server was failing to connect with the following error,

(Robert Sheldon) In any commercial setting, Excel Spreadsheets remain the preferred way of collecting and analysing data, and it makes sense that it should be easy to get the data into PowerBI so it can be made more generally available for sharing and further analysis. As well as the data, we’d prob

(Sergey Gigoyan) The SQL Server database engine has all the necessary functionality allowing developers to write fully isolated transactions. Thanks to this, it’s possible to write code which will read only the correct data (no dirty reads, no non-repeatable reads and no phantom reads).

(Derik Hammer) In the last post of this blog series, I discussed what a non-clustered index is and how to choose an ideal non-clustered index key. In this post, I will discuss indexes on computed columns and unique indexes.