:CONNECT in SSMS
Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...
2014-03-13
1,452 reads
Upcoming Webinar – Creating Power Map Reporting Solutions
Come join me for this webinar on 4/17/2014 at 11:00 AM EST
Creating Power Map Reporting Solutions
Excel 2013 with Office 365...
2014-03-13
759 reads
Upcoming Webinar – Bringing Power BI Q&A to your Organization
Come join me for this webinar on 4/15/2014 at 11:00 AM EST
Bringing Power BI Q&A to your Organization
Q&A is an...
2014-03-13
761 reads
Whats This Command Bar ?
One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out...
2014-03-13
322 reads
Quick tip: Querying AD with xp_logininfo
We all have blind spots in our knowledge. We don’t know they are there and when we are thinking through...
2014-03-13
741 reads
Tables without Clustered Indexes?
Today, we experienced performance issues with some of the SSRS reports that were deployed as part of the latest application/database...
2014-03-13
3,253 reads
Smart Moves with SQL Server VMs – VM Proximity
Today I am starting a new series of short posts designed to help SQL Server administrators with virtualized SQL Servers...
2014-03-12
779 reads
Setting Up Tabular Models on Windows Azure
In my last post, I discussed how to set up Oracle in Windows Azure. During a customer call, there were...
2014-03-12
2,765 reads
A summary of the SQL Server security #datachat is live
Recently I posted about participating in a #datachat about SQL Server security. As it turned out, we didn’t talk about...
2014-03-12
642 reads
Why Did My Job Fail Anyway?
One of my biggest pet peeves when I check a new SQL Server for a client is the fact that...
2014-03-12
1,067 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers