SQL Server & BI Blog by Andreas Wolter

..ough
After I already launched the SQL Server 2012 together with Microsoft at Cologne this February, this year’s second half I will be speaker at 5 Conferences almost in a row:

• On September 15th I will hold
  “Tracing with SQL Server 2012 Extended Events”
  in Unterschleißheim, close to Munich, Germany at SQLSaturday #170

• On September 19th I will hold 2 sessions:
  “SQL Server 2012 AlwaysOn und Active Secondaries“
  and again
  ”Tracing mit Extended Events”
  in Mainz, Germany at the BASTA! / SQLCon

• On October 2/3rd I will hold the session
  SQL Server 2012 Security for Developers
  in Copenhagen, Denmark at the PASS SQLRally

• From October 22nd – 25th I will hold several sessions on:
  ”AlwaysOn and ReadOnly Routing”, “Data Corruption Survival with CHECKDB”,  “Security” and “Tracing with Extended Events”
  in the track
  ”SQL Server 2012 Toolbelt for DBA’s and Developer”
  in Seeheim, close to Darmstadt, Germany at the PASS Camp

• In November I will hold the session:
  “SQL Server 2012 Security for Developers”
  in Seattle, USA at the PASS Summit

what a year..!

I hope to see you around at some of those places.

I recently was asked, whether the Feature “Script Data” as T-SQL-command INSERT INTO… has been removed in SQL Server 208 R2.

In fact, it was not visible on first sight.

This is how you can find it:

It is still the right-click “Tasks” - “Generate Scripts” –Wizard.

After having chosen the Table(s), the following window appears:

there click “Advanced” and scroll down inside the “General”-part until the Element “Types of data” to script

And there under the following drop-down, it is hidden:

And the German translation “Datentypen, für die ein Skript erstellt wird”, makes it even harder to detect:

Conclusion: Scripting out Data with “INSERT INTO”-commands is a bit hidden – (under SQL 2008 it was under the “Table/View Options”, now under “General” – “Types of data to script”) but still available :-)

www.andreas-wolter.com