You may come across or even inherit a system where many of the users have different default schemas. Usually, this is easy to remedy - you go into Management Studio, right-click the user, and change the default schema through the UI. Or you write an ALTER USER command manually. But what if you have hundreds of users, across all of your user databases, that should all have the same default schema?
SQL Saturday is a free day of SQL Server training and networking coming to Washington DC on December 7. Paid pre-con sessions for this SQL Saturday are available.
Today Steve Jones talks about some of the problems in SQL Server. Should we be documenting the situations in which features don't work well?
In this series on implementing data services in Azure, Marcin Policht turns his attention to the remediation of incompatibilities resulting from of limitations inherent to Platform as a Service (PaaS) based deployments, which will need to be addressed as part of the migration process.
Steve Jones knows that good development practices require lots of skill and practice, but the basis for stability with your code is version control. He talks about some reasons why you might want to implement it.
For loading text, CSV or XML files into SQL Server, the Log Parser utility, with its amazing SQL engine, is likely to be the obvious choice. Although initially developed purely for converting IIS logs, the Log Parser can turn its hand to a range of formats including even event logs or the Windows registry.
A CLR Procedure that performs multi-threaded fie copies without external command line tools.
How can you measure someone's DBA skills? Steve Jones comments on a new technique that someone suggested to him.
Understanding indexes and how they work can be complicated enough for a Jr. DBA, but throw in all the different options and properties and an index can soon be overwhelming. Brady Upton takes an introductory look at creating an index in SQL Server using SQL Server Management Studio. He explains what each index property is meant for and the various options presented.
Introduction into Locking, Blocking and Deadlocks in SQL Server, and why SQL Server uses these actions.
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
WHATSAPP 087781685658 Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi, Kota Jakarta...
Cyber 2, Gedung Menara Karya,WHATSAPP 087781685658 Jl. H. R. Rasuna Said Ground Floor, RT.7/RW.2,...
Comments posted to this topic are about the item We Are Eating Our Own...
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers