Even though Service Pack 1 for SQL Server 2012 was released almost 2 months ago, it's only now that I've had a chance to check if the FileTable security flaw was addressed. And I am pleased to report that the problem was resolved with the release of Service Pack 1, so that is good news … Continue reading FileTable Security Flaw Resolved in Service Pack 1
In this third and final post in my Windows 8 experience series, I am thinking about the lack of compelling new features in the OS and some of the positive aspects of Microsoft's latest flagship OS release. If you need to review, the first part addressed the Start menu, the second part the Tablet PC … Continue reading My Thoughts on Windows 8: Part III
This is the second blog post with my thoughts about Windows 8. This time, I have some gripes about the Tablet PC Input Panel which leads to concerns about the integration of the Modern UI with the desktop UI. In the first post, I discussed the Start Menu. In the last part, I am coming … Continue reading My Thoughts on Windows 8: Part II
Note: This blog post became so long, I've decided to break it up into several installments. Here is the first one, where I discuss changes that were made to how search works in the start menu. The second part focuses on the Tablet PC Input Panel and general UI issues. The third part deals with … Continue reading My Thoughts on Windows 8: Part I
If you've been thinking about getting a hard copy of the The Art of SQL Server FILESTREAM, you can get immediate gratification here. However, if you're the betting type, you can enter in Red Gate's Book Giveaway, which includes this book. Enter today, and let me know if you win a free copy of The … Continue reading Red Gate Book Giveaway includes The Art of SQL Server FILESTREAM
I ran into this error today in SQL Server 2012. It was caused by having promoted a package-level connection manager to project-level and then copying and pasting some data flow components from one package to another in the same project. By copying the data flow components from one package to another, the SSIS designer also copied a … Continue reading SSIS 2012: Failure Saving Package: An Item With the Same Key Has Already Been Added
Edit/Update (2012-12-11): MSDN has now published a 2012 version of the same tutorial: http://msdn.microsoft.com/en-us/library/ms169917(v=sql.110).aspx For SQL Server 2008 R2 Integration Services, Microsoft created a series of tutorials (http://msdn.microsoft.com/en-us/library/ms167031(v=sql.105).aspx). One of those was a nice step-by-step example of creating a basic ETL package. When I teach the undergraduate data warehousing class at Troy University, I have … Continue reading Updating the SSIS Tutorial: Creating a Simple ETL Package to SQL Server 2012
Many people have their opinion about passwords and the role they should or should not play in information security. I have an opinion too, but I also realize that today, passwords are simply necessary and we should keep trying to educate end-users about the importance of strong passwords and not re-using them (which is very … Continue reading Google Password Strength Indicator: Weak?
On Tuesday, I delivered a new talk to the Birmingham, AL SQL Server Users Group (a PASS chapter): Configuring and Managing FILESTREAM and FileTable in SQL Server 2012. We had a good turnout, and despite having some trouble pasting UNC paths in Windows 8's Windows Explorer, I think I got some important points about FILESTREAM … Continue reading Steel City SQL Server Users Group Presentation
In the last blog post about FILESTREAM, I discussed the impact of the MAXSIZE setting for the data container. I encourage you to review that blog post first. This time, let's review a new feature that was added in SQL Server 2012: the ability to have multiple data containers in a single filegroup. This feature … Continue reading FILESTREAM with Multiple Data Containers (Files)
Sven Aelterman 