I’m Not Attending #sqlpass Summit 2012 and I’m Sorry For Myself
I really wanted to attent PASS Summit this year, I’ve never attended before. I was preparing myself mentally since the...
2012-10-12
681 reads
Samuel Vanga
Book Review: SQL Server 2012 Integration Services Design Patterns
This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly...
2012-09-14
2,768 reads
SCRIPT: Find the row count of all tables and views
Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and...
2012-08-15
13,488 reads
SQL Saturday US Map
Apparently, SQL Saturday isn’t popular in the west. See for yourself. I wanted to see what cities frequently host SQL...
2012-08-03
1,543 reads
SCRIPT: Basic Information About Indexes
I’m having a little fun with documenting basic information about indexes in my current project. I’m posting the scripts here...
2012-07-31
2,066 reads
Parallel Execution in SSIS with MaxConcurrentExecutables
MaxConcurrentExecutables, a package level property in SSIS determines the number of control flow items that can be executed in parallel....
2012-07-20
18,214 reads
Generating Surrogate Keys With SSIS
A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key...
2012-06-28 (first published: 2012-06-24)
7,580 reads
Status Column in SSISDB Catalog Database
I occasionally review the search terms people use to get to this blog and secretly celebrate knowing my post helped...
2012-06-19
1,192 reads
T-SQL Tuesday 31: SSIS 2012 Logging
Topic for this month’s T-SQL Tuesday, hosted by Aaron Nelson (@SQLVariant) is Logging.
I like to think of logging as a...
2012-06-19 (first published: 2012-06-12)
3,786 reads
Tips to improve your blog, really!
As I learnt a few things about blogging, I made a list of tips to get better at blogging. Thought...
2012-05-17
902 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers