Do Alpacas Dream of farming DBAs?
When IT starts to stand for 'Implement This', even the keenest DBA begins to dream of farming Alpacas as a career-change...and we ask our readers how they would have solved the DBA's dilemma.
2007-09-07
2,439 reads
When IT starts to stand for 'Implement This', even the keenest DBA begins to dream of farming Alpacas as a career-change...and we ask our readers how they would have solved the DBA's dilemma.
2007-09-07
2,439 reads
Warning: This script has no DBA value, but is useful for DBAs who have inclination towards occultƒº.Yesterday I had to decide the name of my new website. Since I wanted the name to be numerological correct. I wrote a T-SQL script for the same.For those of you who are not familiar with Numerology let me […]
2007-11-12 (first published: 2007-09-04)
623 reads
This SP will be create C# classes using all table in the specified Database
2007-11-13 (first published: 2007-09-04)
2,524 reads
Continuing with his series on Alias Data Types, Yakov Shlafman shows us how to work wtih ADTs when constriaints are involved.
2007-09-03
3,705 reads
Organizations with mature business intelligence environments can integrate fraud analytics within their current environment to take advantage of processes and architecture that are already in place.
2007-09-03
1,523 reads
this procedure takes a sql login name and returns information about the login.anyone who knows Sybase will recognise the name and layout. use :- exec sp_displaylogin 'loginname' to get login information returned.this procedure has been tested on SQL Server 2005 sp2any problems email pgr_consulting @ yahoo.com
2007-11-09 (first published: 2007-08-31)
1,229 reads
Get space for all user defined table information like size and row counts.
2013-12-27 (first published: 2007-08-29)
7,713 reads
SQL Server MVP Simon Sabin brings us a very interesting article on a possibilltyfor using enumerated values instead of integer or other coded foreign keys. It is an interesting idea that could go a long way towards making code easier to read.
2007-08-28
13,081 reads
2013-12-19 (first published: 2007-08-27)
20,902 reads
Delete duplicates with a CTE (common table expression).This script uses the same setup as the anonymous post using a cursor (http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1872).
2007-08-23
1,124 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Telp/Wa+62 821-8200-174 Jalan Raya Condet RT 006/03 Kec. Kramat Jati, Jakarta Timur 13530, RT.1/RW.3,...
Telp/Wa+62 821-8154-374 Jl. Balai Pustaka Timur, Blok J No. 225, C, RT.4/RW.3, Wil, Kec....
Comments posted to this topic are about the item Admin Rights for Everyone
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers