(Diana Moldovan) A few months ago I had to fix a SQL Server collation issue for a database, so that the application could access the database. This involved the change of the collation for about 4000 columns for 700 tables. I used a PowerShell script to create the “alter column” and “drop / create i

(Diana Moldovan) A few months ago I had to fix a SQL Server collation issue for a database, so that the application could access the database. This involved the change of the collation for about 4000 columns for 700 tables. I used a PowerShell script to create the “alter column” and “drop / create i

(Pinal Dave) I used to run a series on Hero’s and Sherlock Holmes is one of my favorite. There is always a need to get to the bottom of the problem statement and whether you are a developer or a DBA, at least once you might have been asked one of the following “Who” question after a disaster.

(Pinal Dave) I used to run a series on Hero’s and Sherlock Holmes is one of my favorite. There is always a need to get to the bottom of the problem statement and whether you are a developer or a DBA, at least once you might have been asked one of the following “Who” question after a disaster.

(Jason Brimhall) So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into what an Event is within Extended Events.

(Ahmad Yaseen) Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. How can you grant access to a user for all databases on a SQL Server instance?

(Adam Aspin) SQLXML isn’t exactly new technology, and parts of it aren’t pretty, but if you need to heave vast quantities of XML data into a SQL Server database then you may come to appreciate the raw speed of which it’s capable.

(Richard Carr) Some queries and other operations should yield different results depending upon the user executing them. Sometimes this can be controlled by standard SQL Server security. When it cannot, it may be necessary to identify the current user from Transact-SQL.

(Jason Brimhall) So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into what an Event is within Extended Events.

(Ahmad Yaseen) Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. How can you grant access to a user for all databases on a SQL Server instance?