Who is online?  0 guests and 0 members
Home  »  Blogs  »  KathiK

Communifire Blogs

Blogs RSS Feed

KathiK : Most Recent postings

KathiK

DTS to SSIS Migration Project

6/22/2012 by KathiK  -  Comments: 0  -  Views: [2514]

With much fanfare, SQL Server 2012 launched earlier this year. With all the excitement about the new features, such as AlwaysOn Availability Groups, lots of new T-SQL functions, and ColumnStore Index, there are also features that go away. With each release of SQL Server, features are deprecated, and, eventually, those features are removed from the product. Two things that will impact many shops are the end of SQL Server 2000 compatibility level and the end of DTS . I have spoken with lots of DBA...

Read More

KathiK

Temp table scoping issue

6/22/2012 by KathiK  -  Comments: 0  -  Views: [1376]

A customer approached me with a strange problem. They were using one of the system stored procedures, s p_help_log_shipping_monitor , to make sure that log shipping was up to date before running a report against the secondary database. The system stored procedure returns a lot more data than they needed to see, and they wanted to filter the results based on a database name. In fact, they only really wanted one piece of information from the system stored proc, the status column. They came up with...

Read More

KathiK

Copy files to virtural machines running in Virtual Box

6/22/2012 by KathiK  -  Comments: 2  -  Views: [47757]

In my new job, I am using Virtual Box from Oracle for presentation demos, testing and learning more about SQL Server. When I was at Microsoft, I used Hyper-V for all of that. Hyper-V is a great solution for virtualization, but it is a real pain for running demos and testing on a laptop. Virtual Box runs on Windows 7 which is why I am using it now instead of Hyper-V. One of the first things I had to figure out when using Virtual Box, was how to copy files from my laptop, onto the virtual machines...

Read More

KathiK

Set up shared storage with a VM

6/22/2012 by KathiK  -  Comments: 0  -  Views: [3491]

Creating a SQL Server Failover Cluster in virtual machines is a fantastic learning experience, especially if you have to do everything yourself, not just the SQL Server install. One thing you may be wondering about is how to simulate shared storage if you don't have a SAN available. Luckily, Microsoft has a free download that you can use to do just that. In this blog, I'll show you how to set up shared storage using only virtual machines. You will need two VMs, one will serve as the storage, and...

Read More

Page 1 of 1 (4 items)

Blog Archives