#sqlcoop

Summit 2014 Experience Or My Week With the Aussies #Summit14 #SQLPass #SQLFamily #SQLAussieFamily

Summit may officially only have three days…five days if you count the two pre-con days, but my “Summit 2014 Experience ” this year was two weeks long. How can that be? Well, I hung out with my favorite Aussies.

(I will apologize right here. This is a looong post. I created a timeline for those that want the short version.)

#SQLAussieFamily comes to visit

Some of you may know that I’m really close…

Going Beyond The INSERT Statement #SQLCoOp #RedGate #SQLPass #SQLServer

The Seventh Mission

In this installment of SQLCoOp, we are writing about CRUD. No, this is not about the stuff you scrape off the bottom of your shoes after hiking. This is Create, Read, Update, and Delete. I’ll be focusing on create, which is done with the INSERT Statement, but I’m going to go beyond the basic INSERT statement.

Multiple Rows

Let’s start with a new feature of the basic…

SQL Server Data Transferred to a SQLite Database Using SSIS #SQLCoOp #SSIS #SQLPass #SQLite

The Sixth Mission

In this installment of SQLCoOp, we are writing about SSIS. For me, this happens to tie closely with my the June SQLCoOp post I wrote, called Data Models, SQL Server, SQLite, and PowerShell. In that post I walked through how to create a data model in ER/Studio Data Architect and have it end up in a SQLite database. In this post I’ll show how to use SSIS to get master data from a…

Becoming a SQL Prompt Power User #RedGate #SQLCoOp #SQLPass #SQLServer

Four SQL professionals gathered from the four corners of the world to share their SQL knowledge with each other and with their readers: Mickey Stuewe from California, USA, Chris Yates from Kentucky, USA, Julie Koesmarno from Canberra, Australia, and Jeffrey Verheulfrom Rotterdam, The Netherlands. They invite you to join them on their quest as they ask each other questions and seek out the answers…

Data Models, SQL Server, SQLite, and PowerShell #SQLCoOp #SQLite #SQLPass #SQLServer

The Fourth Mission

In this installment of SQLCoOp, we are sharing our views on something we’ve learned this month. While I learned quite a bit this month in order to create a new SQLite Database with test data that mapped back to my SQL Server database, I will limit this post to how my first PowerShell script aided me in creating a new SQLite Database from Embarcadero’s ER/Studio Data Architect.

New and Improved SQL Search By Red Gate

The Third Mission

In this installment of SQLCoOp, we are sharing our views on the newly released SQL Search 2.0 product by Red Gate. This amazing product is free to the public and can be downloaded here.

    SQL Search is one of those amazing products that you just can’t believe they give away. While I always find it useful, I found it the most useful this year when I was getting to know a new…

On a SQL Collaboration Quest #SQLCoOp #SQLServer #SQLFamily #SQLPass

Announcer: Twelve SQL Professionals started on a quest.

Director: No, no. They were FOUR SQL Professionals.

Announcer: Four Professionals started on a quest to find the sequel to the Holy Grail.

Director: No, no. They were SQL Professionals and they were on a quest for knowledge.

Announcer: Oh, right, right. Four SQL Professionals started on a quest for knowledge and not for the Holy Grail. All…