SQL

One method to synchronize SQL users in AlwaysOn groups

Posted on

I have recently started working with AlwaysOn availability groups. The suggested method to deal with users in AlwaysOn groups is with partially contained databases, then the user is in the DB only, which is replicated to all nodes. However, there are some situations where you cant make a DB a contained DB. One of the […]

DR

Automating multiple RedGate restores

Posted on

I recently had the task to do a DR restore several SQL databases using RedGate backup software. The software is incredible and does things very well, but I had to restore 3 servers each with dozens of databases – not something to be done by hand. Here are a few tricks I learned during the […]

SQL

Bulk importing CSV files into SQL

Posted on

I am working on a way to import the NAR files from my EMC CX4s to a SQL database. I have been reviewing the performance data of several databases, and have realized that not all the LUNs need as much performance they were sized for. As such, I have been able to reclaim some disk, […]

Avamar

EMCWorld – 2 days down

Posted on

Day 2 at EMCworld ended with a bang. Lots of great sessions and lots of fun. So far I have seen: The future of consumer driven IT Enterprise IT growing and being as nimble as consumer technology Virtualized information world, where people no longer work on “documents” at “deskops” but work with information from anywhere […]

Cloud

Oracle Database Cloud

Posted on

I was sitting in the Storage Administrators Guide to Deploying and Managing Oracle DB Clounds on EMC Storage at EMCWorld, and the brought up an intersting idea – a database cloud. I had previously heard about Oracle Real Application Clusters (RAC), a clustered, scalable, high-performance database solution. I had also thought about putting multiple Oracle […]

SQL

SQL query to list all VMs and HW version

Posted on

I had a need to find all of my VMware VMs of a certain hardware version in order to compare to another list. Since I have production, test, and DR virtual machines, it was also important to know the path in the VMware hierarchy so I could easily identify the VM types. use VCenterdeclare @VMs […]

SQL

Migrating SQL servers

Posted on

In the process of our SCOM rollout we used a temporary server for our SQL databases. Finally the new hardware came in, but now we have to migrate the databases with minimal downtime. This is compounded by the fact that the new server is 64bit OS and SQL, where the original was 32bit. For posterity, […]

SQL

TSQL script to shrink all log files

Posted on

I got alerted over the weekend to a SQL server running out of disk space on one of its drives. Upon further inspection, several of the LOG files had grown and were filling the log drive. I went to shrink the files, but realized there must be a better way. A little googling and I […]

SQL

IF EXISTS in SQL

Posted on

For some reason, I always forget the syntax to using IF EXISTS in SQL. Here is a posting that spells it out nicely (http://blogs.msdn.com/miah/archive/2008/02/17/sql-if-exists-update-else-insert.aspx) SQL: If Exists Update Else Insert This is a pretty common situation that comes up when performing database operations.  A stored procedure is called and the data needs to be updated […]

SQL

Connecting to Windows Internal Database

Posted on

I recently had to retrieve some information from a WSUS server and was unable to connect to it from my management station. A little research identified that it was using the Windows Internal Database, which doesnt allow remote connections. Below is from http://www.mssqltips.com/tip.asp?tip=1577 that describes how to overcome this shortcoming. Problem Microsoft products such as […]