Data Head
Well, it’s official. I am a Data Head. It doesn’t change too much my level of geekiness. But I may...
2011-09-27
771 reads
Jason Brimhall
Data Head
Well, it’s official. I am a Data Head. It doesn’t change too much my level of geekiness. But I may have to rethink one of the answers given during...
2011-09-27
In The SQL News
There is a lot of stuff going on out there these days. I am looking forward to a few things. And since I am looking forward to them, I...
2011-09-23
1 reads
In The SQL News
There is a lot of stuff going on out there these days. I am looking forward to a few things....
2011-09-23
551 reads
September Performance Contest
This month SafePeak is sponsoring a contest centered around improving performance in SQL Server.
The host of the contest is my...
2011-09-21
1,078 reads
September Performance Contest
This month SafePeak is sponsoring a contest centered around improving performance in SQL Server. The host of the contest is my friend Robert Pearl. You can read the announcement...
2011-09-21
Stored Procedures – Common Security Practice
In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at the document available in that link. To further this...
2011-09-20
6 reads
Stored Procedures – Common Security Practice
In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at...
2011-09-20
891 reads
Column Level Permissions
Did you know that you can grant permissions down to the column level in SQL Server? Well, if you didn’t...
2011-09-19
1,666 reads
Column Level Permissions
Did you know that you can grant permissions down to the column level in SQL Server? Well, if you didn’t know that – you do now. It is...
2011-09-19
27 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers