Download Attachments from Exchange Web Services using SSIS
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
5,124 reads
The Shield
How many of you are known as the “Grumpy DBA” or have a bad reputation with users because you are...
2016-03-11
275 reads
Are You Data Driven? SQL Server 2016 revealed!
By now, all you folks who logged on to watch the ultimate Microsoft Data Driven event, streamed live from New...
2016-03-11
1,265 reads
Reblog: MDS – A Database Error Has Occurred
I recently came across the following error message when I tried to look at the batches in the Integration Management...
2016-03-11
825 reads
Monday Morning SQL Break – February 22, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-03-11
469 reads
Extraordinary #1
I’ve seen tables that are referenced by many other tables in MSSQL databases and that number was usually being around...
2016-03-10
122 reads
Different ways to find Data, log and DB Size
Different ways to get the size of the data , log files and Databases
Using CountersQuerying sysaltfiles & sys.databasesQuerying sys.master_files
SELECT instance_name AS DatabaseName,
[Data...
2016-03-10
1,111 reads
PASS Cloud Virtual Chapter – Call for Presenters
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community...
2016-03-10
372 reads
January MVP – Mike Fal
In case you missed it, back in November I blogged about the importance of nominating individuals within the SQL Server...
2016-03-10
391 reads
You don’t need to be a sysadmin
Hey, I need sysadmin access to ServerA.
Ok. Why do you need sysadmin?
Well I need to be able to read and...
2016-03-16 (first published: 2016-03-10)
2,324 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