Browse by Tags
All Tags »
SQL Server (RSS)
At the beginning everyone is trying to tune the database by creating additional database files, spreading the data across file groups, adding additional log files for the database… But wait a minute, is there a performance benefit from having more than
Read More...
As a follow-up to my former post “ Why you shouldn't´trust the friendship of NULL and the (NOT) IN predicate ” I asked Paul Randal during our SQL Server Master training about the possible internal reason that the results can vary if you have NULL
Read More...
Ever wanted to get feedback and interim results like a progress from a stored procedure ? Well, not that easy as the results such as PRINT information is send after the batch has been completed. If you want to get information back from your batches you
Read More...
Coming as a simple sample with PBM (creating a policy with a condition that procedure names shouldn't´t start with SP_) and getting an interesting question in one of my classes, I wanted to revisit the question about the yet in some places existing naming
Read More...
SP_who2 has become a very handy tool for administrator, DBAs developers or all who are the All-In-One role) to get information from the processes table and get the appropriate information by just issuing this command form the command line. Easy if you
Read More...
A colleague (Cornel Sukalla) asked me what the protocol_version in sys.dm_exec_connections is all about. From the output it seems that its an INT presenting the version for the protocol used by the client. With some research and having in mind that those
Read More...
The easiest way for querying all system databases of a server is to assume that databases create by a user come with a database_id >= 5 in sys.databases. But the problem is that distribution databsaes will not be kept into this consideration. Therefore
Read More...
Here are some instructions how to change the Login / authentication mode via Code. It just uses plain SMO capabilites: After this you will have to make sure that the Service is restarted, if you want this to do via SMO look at the following sample. You
Read More...
SQL Server 2005 introduced an interesting and long demanded feature, the LOGON triggers. First only defined via server event triggers, it has become more and more popular in same scenarios to prevent users with a certain machine environment accessing
Read More...
Thanks for the interesting SQL Server Developer conference of Karl Donabauer . Scripts and Demos are attached. Hope you enjoyed it and we´ll meet again :-) -Jens
Read More...
