Learn A Bit More
For this Friday's poll, Steve Jones talks about free training events and what their value is to you.
70-433 Or Bust: Working toward MCTS Microsoft SQL Server 2008 Database Development
The 70-433 will be my first Microsoft certification test. There are two main reasons why I've decided to take on this quest. The first reason is to "fill in the cracks." Even on fundamental topics I've found myself saying "oh
Attribute Discretization: Customize Grouping Names
Join BI Architect Bill Pearson as he continues to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.
Learn A Bit More
For this Friday's poll, Steve Jones talks about free training events and what their value is to you.
Learn A Bit More
For this Friday's poll, Steve Jones talks about free training events and what their value is to you.
Learn A Bit More
For this Friday's poll, Steve Jones talks about free training events and what their value is to you.
Troubleshooting Performance Problems in SQL Server 2008
This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.
More Can Come From Less
Becoming a more productive employee should be a goal for most people. It can also greatly increase the enjoyment you get from your career. Steve Jones gives you some ideas that might help you.
Stop and Start Services - SQL School Video
SQL School covers a basic topic this week. MVP Andy Warren shows the various ways to stop and start your services.
Creating and managing Analysis Services partitions
S partitions from the ground up, with advice on binding, merging, and selecting partition data.
Blogs
“SQL Server Is Slow” Part 4 of 4
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
How to Install DBeaver and Connect to a PostgreSQL Instance
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
DBAs should never run SSMS under their everyday Windows account If you open SSMS under...
Forums
Extract from sql.to multiple sheets
Import-Module ImportExcel # Path to your .sql file $sqlFile = "C:\Data\MyQueries.sql" $excelPath = "C:\Data\SqlExtract_$(Get-Date...
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Question of the Day
Who am I?
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)
END See possible answers