The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 280,000 times in 2013. If it were an exhibit at the Louvre Museum, it would take about 12 days for that many people to see it.
Click here to see the complete report.
Filed under: SQL Server 2008 R2
The recently proposed bylaw changes to the Professional Association for SQL Server charter are a good change. But there’s a hidden issue that you may not have seen. What is the issue? And what are its ramifications? Read more and add your opinion here….(read more)
I want to implement TDE on my SQL Server 2012 databases and join them in an Availability Group. This can’t be done using the SSMS GUI, so in this tip we walk through step by step how this can be done using T-SQL.
SQL Server 2014 introduces In-memory OLTP to create memory optimized tables for OLTP workloads to significantly improve performance and reduce processing time when you have a significant amount of memory and multi-core processors. But how do you decide which tables or stored procedures might benefit if migrated to In-memory OLTP and how much estimated work is required to migrate the objects? Check out this tip to learn more.
Testing for logic errors in SQL Server Analysis Services Key Performance Indicators (KPIs) can be cumbersome at times. In this tip we look at how you can test your KPIs.
SQL Server 2014’s In-Memory OLTP feature is intended to significantly improve performance and reduce processing time for servers with large amounts of memory and multi-core processors. What types of applications can take advantage of this new feature? What are the different types of indexes which can be created on memory optimized tables? Are there any considerations, restrictions or limitations? Check out this tip to learn more.
I am honored to present Using Biml as a Design Patterns Engine to the Midlands PASS Chapter Thursday 9 Jan 2014! Summary: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns , demonstrates the flexibility of BIML in this session. Register here ! If you will be near Columbia, SC one week from Thursday and read this blog, stop by and introduce yourself. I’m the fat guy with a fu….(read more)
In this tip we look at how to import XML documents into SQL Server using SSIS. We will walk through an example and also show some of the potential issues and how to resolve them.
It may happen, that you need to execute a child SQL Server Integration Services (SSIS) package many times like in case of processing large number of flat files from a directory. You can execute a child package in a sequential way using For Each Loop container, however this can take a long time. In such scenarios, a running SSIS packages in parallel comes into mind. But how do you do it? Check out this tip to learn more.
I have been hearing the term Big Data for a while now and would like to know more about it. Can you explain what this term means, how it evolved, and how we identify Big Data and any other relevant details.