Latest Blog Posts
Big news for us in Orlando! On October 15th Mark Souza, General Manager – Data Platform Group at Microsoft, is going to speak to a joint oPASS/MagicPASS chapter meeting. Just having a joint meeting is a big deal, but having Mark as the speaker – hard to believe! The… Read more
A discussion that I’ve frequently had with organizers of SQL Saturday events, our own people here at Red Gate, authors, MVPs, pretty much anyone interested enough to listen for a few minutes, is summed up by “How do we get the word out about the opportunities that the SQL Server… Read more
Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools.
The simplest way is to select all results and then copy & paste them into whichever… Read more
Fun trivia fact: This will be the first time I'll have spoken at a SQL Saturday east of Baton Roug
Just checked in on my LinkedIn campaign. This is the one that uses job titles. Not a ton of impressions, but I can live with that at this level of targeting. Going to send this off to the team, we might run this longer given the low weekly spend.
Tomorrow… Read more
Many of you may already know that I am a PASS regional mentor for the South Central region of the United States. My role is to help user group leaders obtain the tools they need to have successful groups and provide an open platform to discuss challenges and successes. One… Read more
0 comments, 119 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 18 August 2014
I’ve been working on some skills, trying to grow some of my T-SQL, and started to mess with the PIVOT operator. This is a T-SQL construct that helps you turn row data into column data. It’s part of the SELECT query, and comes about in the FROM clause. There… Read more
In order to speed up our backups on a large database our team decided to stripe the backup files. In case you weren’t aware of this particular backup feature it his means that a single backup is written to multiple files which can dramatically speed up your backups and restores.… Read more
SQL Server Keyboard Shortcuts for Management Studio
SQL Server Management Studio is filled with lots of optional settings that lets you maximize your development experience. There are a few helpful settings and shortcut keys that will help you get the most out of the tool while working on database activities.… Read more
Many times, when I perform query tuning, the problem that causes the query to perform badly is related, one way or another, to parameterization.
On one hand, parameterization is a fundamental subject in the heart of the query processor. It can affect query performance dramatically. On the other hand, it… Read more
Step 1:- Open the SQL Sever Management Studio. For this…
- Using Create Database command
- Using SQL Sever Management Studio (SSMS).
In this article, I am going to explain the database creation using the command CREATE DATABASE.
Syntax for creating a database through Create database command is given below:-
- ONETUG team graciously gave me time at the beginning of the meeting to talk about the upcoming SQLSaturday Orlando
- Asked them to attend – I think people like to be asked, and we really do want them to attend!
- Mentioned our paid seminars
- Asked them to mention the event to…