oPASS June 2015: Using BI Power tools to visualize your SQL Infrastructure with Rodney Landrum
The next oPASS meeting is tomorrow night (June 25, 2015):
DBAs do not always have time to work with some of...
2015-06-24
395 reads
SQLAndy
Seeking Full Day Seminars For The Friday Before SQLSaturday Orlando 2015
We’re planning to run one or two (or maybe even three) seminars (aka pre-cons) in conjunction with SQLSaturday Orlando 2015....
2015-06-24
489 reads
Use 100% Fill Factor on Insert Only Tables
SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page...
2015-06-24
798 reads
SSC Editorial: Sweat Files and Practice Projects
Published last week on SQLServerCentral, Sweat Files and Practice Projects is about the need/lack of packaged projects that a newbie...
2015-06-23
336 reads
Notes from the June 17, 2015 MagicPASS Meeting
Notes:
Kendal has been doing an exam push focused on 70-461. A couple passed so far, a couple more tried and...
2015-06-18
370 reads
Presenting at the Space Coast SQL Group on August 13, 2015
I’m heading to the coast on August 13, 2015 to talk about database corruption, SQLSaturday Orlando, and the possibility of...
2015-06-17
290 reads
Presenting at the Jacksonville SQL Group on September 16, 2015
I’ll be driving up to speak to the Jacksonville SQL group on September 16, 2015 on database corruption. Meeting starts...
2015-06-17
365 reads
Publicizing Mistakes
I was reading Our Journey to Cloud Cadence, Lessons Learned at Microsoft Developer Division and saw this bit on transparency:
“No incident is...
2015-06-16
460 reads
Working With Sponsors
Apologies for the poor photo, the example was trampled a bit on the journey home! This past weekend at SQLSaturday...
2015-06-15
389 reads
Marketing Materials for PASS Chapters
I brought this back with me from SQLSaturday South Florida. It’s postcard sized and laminated, and information dense in a...
2015-06-15
413 reads
Blogs
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers