(Pinal Dave) After reading my post SQL SERVER – Puzzle – Playing with DateTime with Customer Data, one of my blog readers asked me “How to find out the current language setting of the session?”
Tag: sql server
(Kenneth Fisher) Ever looked at the list of databases and wonder why you own one of them? Or why some other user owns the database? Just to be clear, by owner I mean the one and only actual owner of the database, not just a member of the db_owner role.
(Joseph Sack) SQL Server 2019 introduces several performance optimizations which will improve performance with minimal changes required to your application code.
(Carlos Robles) SQL Server Query Store data persists on disk even after backup and restore operations, let’s imagine a production database is restored in a QA environment for UAT because testers want to use the latest data from production.
(James Rhoat) Corruption is a looming thought through every administrator’s mind, from sysadmins to database administrators there is always a monster hiding in the shadows.
(blobeater) Have you ever wanted to capture the T-SQL, waits, sessions IDs (etc) at a specific time for Azure SQL Database?
(Steve Endow) I’ve been fighting this error for years in my Data Access class. Only yesterday did I figure out the cause.
(Pinal Dave) I am not sure what changes I made in one of my Virtual Machine, but I was running into an issue. In this blog, we would discuss how to fix error “The ‘SqlStudio Profile Package’ package did not load correctly” while launching Visual Studio.
(Dennes Torres) SSMS new versions are full of very interesting features. With SQL Server 2019 arriving, it’s normal that our focus is captured by the new features in the database engine, however, SSMS has also a lot to offer.
(Jovan Popovic) Checking file performance and comparing performance characteristics between SQL Server database engines in Azure cloud and your on-premises environment might be tricky and require some better knowledge of DM objects.