2012-01-18
9 reads
2012-01-18
9 reads
2011-08-24
10 reads
What are the most influential papers in the world of Big Data? Let me suggest:...
2011-05-30
5 reads
2011-05-02
3 reads
2011-02-02
7 reads
2011-01-05
6 reads
I searched the internet for “connect and forget”. Wonderbox.net offer is described as a...
2010-10-10
4 reads
10 years ago IT professionals considered database technology “mature” and analysts were preparing to...
2010-09-13
8 reads
“The information age is an idea that the current era will be characterized by the ability of...
2010-08-22
1 reads
“Content is king” is the golden rule of the SEO. The semantic web is all about data. Any web...
2010-06-25
9 reads
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
By gbargsley
Whether you’re a seasoned DBA or just exploring database tools, DBeaver offers a powerful,...
DBAs should never run SSMS under their everyday Windows account If you open SSMS under...
Immediate need for a hands-on SQL Server DBA. This is a greenfield opportunity to...
Import-Module ImportExcel # Path to your .sql file $sqlFile = "C:\Data\MyQueries.sql" $excelPath = "C:\Data\SqlExtract_$(Get-Date...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer @customername varchar(200) AS BEGIN DECLARE @added VARCHAR(100) SELECT @added = xxx IF @customername IS NOT NULL INSERT dbo.Customer ( CustomerName, AddedBy ) VALUES (@customername, @added) ENDSee possible answers