In a perfect world, your SQL Server would be so secure that you would not need antivirus software, you would have behind layers of firewalls, nobody would ever connect with remote desktop to install anything, and it would always have all of the latest security patches… But that is not the real world. Given that your SQL Server often times …

Using Antivirus with SQL Server Read more »

When you look at the installed programs with SQL Server 2014 CTP1 you see the following: There is no BIDS or Visual Studio installed with CTP1 of SQL Server 2014.  After some additional research, and discovering that I didn’t miss something on the installation.  There is no more Business Intelligence Development Studio (BIDS) in SQL Server 2014, instead it can be downloaded …

No more Business Intelligence Development Studio in SQL 2014 Read more »