SSRS Subscription Schedules
Reporting Services
Reporting Services (SSRS) is a tool that permits you to create and deliver feature rich reports. The reports can...
2017-06-06 (first published: 2017-05-23)
4,034 reads
SQL RNNR
SSRS Subscription Schedules
With the ability to create content delivery schedules, or to subscribe to report content delivery, this imposes a requirement to also know when the various reports are scheduled to...
2017-05-23
23 reads
SSRS Custom Shared Schedule
Reporting Services
Reporting Services is a pretty feature rich tool for delivering reports to various consumers. There is plenty of power...
2017-06-02 (first published: 2017-05-22)
6,566 reads
SSRS Custom Shared Schedule
Reporting Services is a pretty feature rich tool for delivering reports to various consumers. Unfortunately, the scheduling capability within SSRS is fairly weak.
Related Posts:
CRM Data Source Connection Error January...
2017-05-22
59 reads
T-SQL Tuesday #089: The Cloud and Job Security
The Cloud
Today I am doing a quick entry for my participation points in the monthly blog party called TSQL Tuesday. I...
2017-04-12
596 reads
T-SQL Tuesday #089: The Cloud and Job Security
Do you fear the coming turbulence of the Cloud uprising? I think the cloud is a good thing for the data professional, when done right.
Related Posts:
Coping with Self...
2017-04-12
2 reads
SQL Server Fixed Role Permissions
Roles and Permissions
Some of my recent articles have been focused on permissions and security. There is good reason for that – security...
2017-03-15 (first published: 2017-03-06)
3,090 reads
SQL Server Fixed Role Permissions
It is very important to understand who has what level of access within the server and databases on that server. Sometimes we see users being granted server or database...
2017-03-06
9 reads
SQL Server Permissions – Database Roles
EZ PZ Permission Squeezee
Given the critical level of importance related to permissions, one may think it is a concept that...
2017-03-02
1,444 reads
SQL Server Permissions – Database Roles
A fundamental component of SQL Server is the security layer. This article covers three common security misconfigurations in SQL Server.
Related Posts:
When Too Much is Not a Good Thing December...
2017-03-02
69 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
sp_prepare and sp_execute vs sp_executesql
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Question of the Day
Who am I?
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers