The Tethered Goat
Phil Factor's a 'tethered goat' database taught in the value of database intrusion detection and of "defense in depth".
2017-08-07
64 reads
database security
2015-01-20
8,720 reads
SQL University: SQL Server Security Architecture - 3rd Party, Some Options
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
2011-02-11
2,330 reads
You pulled BUILTIN\Administrators, but are you auditing?
The conversation on local administrators having rights in SQL Server has proven to be interesting and at times entertaining. My...
2009-12-10
2,810 reads
Should DBAs have local administrator rights?
This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on...
2009-11-25
8,179 reads
RE: Adding space to middle of string
This is not the prettiest code I've ever written but it works... CREATE TABLE [Numbers] ( [PkNumber] [int] IDENTITY (1, 1) NOT NULL , CONSTRAINT [Pk_Number] PRIMARY KEY CLUSTERED ( [PkNumber] ) ON [PRIMARY] ) ON [PRIMARY] GO Declare @i as int set @i = 0 while @i < 8000 begin Insert into dbo.Numbers Default […]
2005-02-09
RE: Moving SQL Logfiles
Alzdba,Thank you very much for your help. I was successful in completing the procedure as per your recommendation. Thanks again.
2004-06-10
RE: UPDATE Query problem
this is for a text field. the 3rd argument needs to represent a multiple length string and up untill this point I thought % would do this. example: SUBSTRING(FIELD,3,%) 'should return the following: CR20AB = 20AB CR509FDS = 509FDS
2003-07-28
RE: Remote login and password in linked servers
If you are using a remote login in a linked server, that login does not need to be transferred to your new server, just create the Linked Server with the same details as the old server. I don't remember if it is possible to script the Linked Server details, try searching this forum or the […]
2003-07-23
1 reads
RE: Replacing BCP with SQLBulkLoad
quote: I think the BULK INSERT statement is a good substitute to bcp. From a performance perspective, it should be slightly faster. BULK INSERT runs in the memory context of SQL Server whereas bcp does not. Both of these would be faster than DTS and the described method here. K. Brian Kelley http://www.truthsolutions.com/ Author: Start […]
2003-07-21
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers