When Andy Warren and I first talked about SQL Saturday after the initial event in Orlando, we joked about whether we could have twelve events in a year, one a month. It seemed like a stretch goal, after all, how many events can you actually put on where the attendees don't have to pay?
The latest PASS Connector newsletter had the headline of "SQL Saturday: Setting Records" in which there were 86 events in the last year, 34 around the world and 52 in the US.
That's one a week, though there wasn't actually an event every week. We had some busy weeks, mostly in April and September, including 6 events on Sept 14, 2013. That's an amazing number of events where SQL Server professionals around the world are getting a day of training for free. The cost of some events is a nominal fee to cover lunch expenses, but all the speakers give their time, often delivering the same sessions they'd give at a paid conference.
The success of SQL Saturday is due to all the efforts of the hundreds of organizers, volunteers, and speakers who work to give you a great event. If you attend an event, be sure to thank someone for their efforts. However much of the credit for the growth of SQL Saturday really belongs to Karla Landrum (b | t). The addition of Karla to the PASS staff, with her focus and support of event organizers, has made SQL Saturday grow far beyond what any of us might have thought possible at SQL Saturday #1, Orlando, 2007. If you get the chance, thank Karla when you see her.
If you get the chance, I'd encourage you to attend an event in the 2014-2015 fiscal year. If there's not one near you, organize one. You can put on a small event, with a single track, a few speakers, and support from your community. Lots of us would love to help support an event in a new city, even a small one. You might be surprised to see a nationally known speaker at a small event, but you shouldn't be. We love helping the community.
Come learn about Continuous Integration for databases at our Cambridge workshop on Friday, August 8, 2014 at the Red Gate office. Learn to link your source control system to a build environment and automatically generate and test your databases. We will use Subversion and Jenkins in the class, and explain how the techniques can be applied to any other VCS (Git, TFS, Mercurial, etc) as well as any build server (Bamboo, Team City, TFS Build, etc.)
The award-winning SQL Developer Bundle contains 10 tools for faster, simpler SQL Server development. Download a free trial.
14 SQL Server Backup Questions You Were Too Shy to Ask
Read Grant Fritchey’s free PDF and get the answers to some of life’s big questions, like, “How do I retrieve a table from the log?” and, “Are SAN backups enough?” Download the free article PDF.
Getting started with SQL Server?
First things first, install SQL Monitor and begin monitoring your servers to plot baselines and initiate a health check. With baselines in hand, you can find irregularities in performance and use the in-tool advice to resolve or investigate problems. Try it free for 14 days.
Here are seven practical tips for any 'accidental DBA' or developer, faced with having to deploy an upgrade to a database live to production, in a development environment that is in the early stages of getting the database code “house in order". More »
The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Stuart Davies):
Assuming xp_cmdshell is enabled, how many rows will there be in the output file (C:\Exports\data.csv) from the following script?
CREATE TABLE #Employee
[UniqueId] [int] IDENTITY(1, 1)
NOT NULL ,
[EmployeeName] [char](10) NULL,
INSERT INTO #Employee
DECLARE @BcpCommand VARCHAR(250)
SELECT @bcpcommand = 'bcp "SELECT EmployeeName FROM #Employee WHERE UniqueId <= 7" queryout "C:\Exports\data.csv" -c -T '
EXEC master..xp_cmdshell @bcpcommand, NO_OUTPUT
DROP TABLE #employee
Answer: C:\Exports\data.csv won't be created
The answers 0 and 10 are incorrect - if you run the following, this is clearly shown
SELECT EmployeeName FROM #Employee WHERE UniqueId <= 7
7 is also incorrect as the #Employee table is not accessible from the xp_cmdshell context (it would be however if the table was created as ##Employee).
The correct answer is that the file is not created, if you remove the no_output parameter from
EXEC master..xp_cmdshell @bcpcommand, NO_OUTPUT
the following error will be displayed
SQLState = S0002, NativeError = 208
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name '#Employee'.
SQLState = 37000, NativeError = 8180
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.
Calculate EndDate From Subsequent StartDate
- Here is sample data I am working with:
Create table cattimelines (categoryID int, EffectiveDate datetime, CategoryValue varchar(11))
INSERT INTO cattimelines(categoryID, EffectiveDate, CategoryValue)...
TSQL Script help for new user
- Hi all,
I'm hoping someone can help as I'm clueless :)
I'm looking for some TSQL script that filters the method field...
Cluster drive issue
- Running out of space on active/pasive cluster (physical servers attached to SAN). netops added new drive, I see the new...
Non-Buffer Pool is huge size?
- In SQL2008 R2 64 bit, i have setting cape memory 20 GB,
DECLARE @total_buffer INT
SELECT @total_buffer = cntr_value
expression yyyymm with mm-1
- In My derived column I want expression for getting yyyymm ( where mm is mm-1)
Expression in Derived Column
(DT_STR,4,1252)DATEPART("yyyy",GETDATE()) + RIGHT("0" + (DT_STR,2,1252)DATEPART("mm",GETDATE()),2)
Result : 201407
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.