Run command-line stuff from SSMS via SQLCMD Mode  

Posted by ReelTym

By entering SQLCMD mode in a SQL Server Management Studio query window, you can do some very handy things without needing to jump back out to the command prompt. Commands can be run just like at the command prompt, by prefixing the line with "!!" a la:

!!bcp MyDatabase.dbo.MyImportedTable in c:\temp\sqlimport.dat -Umydbuser -Pmydbpass -Smydbserver -n


And by executing (ctrl+e) that line, it'll import your database... easy, and if you save in a database project, you can even have these included in the source control flavor of your choice.

Sammamish 1st Ward - 2011 Sunday Leadership Meeting Schedule  

Posted by ReelTym

1st Sunday
7:30 - 8:00aBishop Planning
8:00 - 9:30aBishopric Meeting
9:30 - 11:00aWard Council
11:00 - 12:00pBYC
12:00 - 12:45pChoir Practice
1:00 - 4:00pChurch
2nd Sunday
7:00 - 7:30aBishop Planning
7:30 - 9:00aBishopric Meeting
9:00 - 9:30aPI: EQ President
9:30 - 10:00aPI: HP Group Leader & EQ President
10:00 - 10:30aPI: HP Group Leader
10:30 - 12:00pYouth & Member Interviews
12:00 - 12:45pChoir Practice
1:00 - 4:00pChurch
3rd Sunday
7:00 - 7:30aBishop Planning (Stake Bishopric Training 7am 1/23, 4/17, 8/21, 11/20)
7:30 - 9:00aBishopric Meeting
9:00 - 9:30aPEC (Review HT/VT)
9:30 - 11:00aWard Council
11:00 - 12:00pAP Quorum Presidency Mtg (Priests)
12:00 - 12:45pChoir Practice
1:00 - 4:00pChurch
4th Sunday
7:00 - 7:30aBishop Planning
7:30 - 9:00aBishopric Meeting
9:00 - 9:30aPI: Ward Mission Leader
9:30 - 10:30aPI: Relief Society President
10:30 - 12:00pYouth & Member Interviews
12:00 - 12:45pChoir Practice
1:00 - 4:00pChurch
5th Sunday
7:00 - 7:30aPI: Executive Secretary
7:30 - 9:00aBishopric Meeting
9:00 - 9:30aPI: 1st Counselor
9:30 - 10:00aPI: 2nd Counselor
10:00 - 10:30aPI: Clerk
10:30 - 12:00pYouth & Member Interviews
12:00 - 12:45pChoir Practice
1:00 - 4:00pChurch