Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

T-SQL Tuesday #59 – My Hero!

It always amazes me how fast these T-SQL Tuesday block parties come about; it seems like we just finished one and here we are yet again. This month the party is hosted by Tracy McKibben (Blog | Twitter) and the monthly topic that was chosen is “Heroes”.

This… Read more

0 comments, 67 reads

Posted in The SQL Professor on 14 October 2014

Operation Souza

This Wednesday we’re having a special joint meeting of oPASS and MagicPASS featuring Microsoft GM Mark Souza. For the past couple months we’ve referred to it internally as “Operation Souza” as we discussed how to best support his visit and do the most for our local SQL community. We contacted… Read more

2 comments, 125 reads

Posted in SQLAndy on 13 October 2014

Last Weeks Top “Reading” Links #104

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

0 comments, 116 reads

Posted in StrateSQL on 13 October 2014

Notes From the October 9, 2014 Space Coast SQL Meeting

  • Not a bad drive over from Orlando. Only a little traffic, about 80 minutes.
  • I was early enough to have time to review my presentation and then work on the final marketing notes for SQLSaturday Orlando (good to have a few tasks queued when time appears)
  • I stopped at Starbucks…

Read more

0 comments, 129 reads

Posted in SQLAndy on 13 October 2014

Creating a Reporting Services Subscription

Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either by email or Windows File Share. Subscriptions can also be scheduled so if your end users need a report monthly you can automate the delivery process. The steps given in… Read more

0 comments, 4,640 reads

Posted in Devin Knight on 13 October 2014

SQL Saturday Minnesota Precon 10/24 – Virtualization for SQL Server DBAs

Coming soon is the SQL Saturday #332 in Minneapolis, MN on October 25th, with my preconference training session on Friday, October 24. I am really looking forward to attending these events!

Virtualization for SQL Server DBAs Precon

There are just a few seats left for the precon! Register today! Read more

0 comments, 118 reads

Posted in Technobabble by Klee from @kleegeek on 13 October 2014

Final Prep for SQL in the City

I can’t believe this will be the fourth SQL in the City in London next week. It’s amazing to me that we’ve managed to build this great series of one day events that is so popular with SQL Server professionals.

I’m heading back to London next week, a quick trip,… Read more

0 comments, 159 reads

Posted in The Voice of the DBA on 13 October 2014

Configure SQL Server Database Mirroring

1) Take Full backup of database at Principle Server

BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’

2) Take Log Backup at Principle Server

BACKUP LOG USERDB1 TO DISK = ‘H:USERDB1_LOG.TRN’

3) Copy both backup files to Mirror server

4) Restore Full backup with No Recovery at Mirror Server

USE [master] Read more

0 comments, 4,860 reads

Posted in MSSQLFUN on 13 October 2014

My Best Technical Sites and Blogs

Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the list of tech sites which I used to refer most of the times for learning technologies and finding the solutions

Mssqltips.com:- I like this site because I find here…

Read more

0 comments, 266 reads

Posted in Vivek's SQL Notes on 12 October 2014

Navel Gazing

I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to think about. Am I presenting the right material? Am I presenting it in the right way? Can I improve? But, in order to get constructive feedback, people have to tell… Read more

0 comments, 4,782 reads

Posted in The Scary DBA on 12 October 2014

SQL Server proxy account and local policy

Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the user runs xp_cmd_shell in the security context of SQL Server service running account. If he is not a member of sysadmin role, the server proxy account must be setup,…

Read more

0 comments, 160 reads

Posted in Coffee and SQL on 11 October 2014

Introduction of Triggers in SQL Server

Triggers are the database objects that are used in relational databases. These are executed or fired automatically, when DDL or DML command statement is executed related to trigger. Triggers are used to assess or evaluate data, preserve data integrity, control server operations, used to implement business logic/rules, or to audit…

Read more

0 comments, 5,340 reads

Posted in Zora's SQL Tips on 10 October 2014

Reblog: October 3 to October 9

Photo credit – Travis

Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing up some of my old posts to… Read more

0 comments, 121 reads

Posted in StrateSQL on 10 October 2014

PASS Summit 2014: Recommendations and Invitations (#sqlpass #Summit14)

The first week of November, we’ll be at the PASS Summit inSeattle, WA.  This is the highlight of most SQL Server speakers’ years…a sort of educational, Christmassy nerdfest, with a feel of a class reunion mixed in. We have a lot of fun, and so I’d like to draw your…

Read more

1 comments, 146 reads

Posted in SQL Awesomesauce on 10 October 2014

SQLSaturday Orlando Marketing Plan-Part 49 (Plan Notes)

Introduction

After finishing up six months of managing the marketing for SQLSaturday Orlando I’ve been going back through all my blog posts to outline stuff we (or any other event) can use next year. It’s not a complete project plan, but I hope it gives you some ideas and a… Read more

0 comments, 198 reads

Posted in SQLAndy on 10 October 2014

Friday Followup For October 10, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Invite for #TSQL2sday #59 – My Hero!
  • Using Encryption To Protect Your Data From Alien Abduction
  • Building (for…

Read more

0 comments, 98 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 10 October 2014

Temporary Post Used For Theme Detection (919ceef8-1031-4873-93f5-7a833585812f – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (e5bad5db-3b7d-4641-ba91-15ab900e8f70 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)


Read more

0 comments, 124 reads

Posted in DataOnWheels on 9 October 2014

SQL in the City 2014 – Two countries in two weeks

I have had a fairly busy travel schedule the last few years. While I don’t love sitting on airplanes and being away from home, I do look forward to the events and seeing the amazing #SQLFamily and community we have for SQL Server. I’ve also learned a few tricks to… Read more

0 comments, 138 reads

Posted in The Voice of the DBA on 9 October 2014

Speaker of the Month: October 2014

I saw a whole bunch of great sessions last month. I was all over the place from Las Vegas to San Diego and then Antwerp and Utrecht at Connections, two different SQL Saturday events and SQL Server Days. The speakers just seem to keep getting better, making this more difficult.… Read more

0 comments, 111 reads

Posted in The Scary DBA on 9 October 2014

Virtualization for SQL Server DBAs 499 Wrap Up

Today I presented the final ramp up session entitled “Virtualization for SQL Server DBAs 499” for the SQL PASS Virtualization Virtual Chapter. It’s the last session in a four-part where the goal is to take the DBA from knowing nothing about infrastructure and virtualization technologies up to… Read more

1 comments, 128 reads

Posted in Technobabble by Klee from @kleegeek on 8 October 2014

Newer posts

Older posts