SQL Server Reporting Services 2012 Permissions
As you begin developing reports for deployment to a Report Server, what security considerations need to be taken into account in order to grant users access to run a report.
Keeping Your Job
A few thoughts from Steve Jones on how you can help increase your own job security in IT.
Routine Dependency Visualizer
This article contains a T-SQL script that can show you the dependency of all objects in your SQL Server database.
SQL Server 2012 Integration Services - Unattended Execution of SSIS Packages
Quite often, tasks accomplished via SSIS are a part of procedures that run unattended, either scheduled to launch at a particular date and time or triggered by some arbitrarily chosen event. Marcin Policht shares a typical approach to implementing such a scenario.
A Tale of Broken BI
Graphs and charts are dangerous in the wrong hands, and if built on data that is carelessly gathered will mislead as often as they lead. Phil Factor speaks from hard experience.
Stairway to XML: Level 7 - Updating Data in an XML Instance
You need to provide the necessary keywords and define the XQuery and value expressions in your XML DML expression in order to use the modify() method to update element and attribute values in either typed or untyped XML instances in an XML column. Robert Sheldon explains how.
The PoSh DBA: Solutions using PowerShell and SQL Server
PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much more than getting information from SQL Server instances via PowerShell; it can also be run from SQL Server as part of a system that helps with administrative and monitoring tasks.
Understanding Column Properties for a SQL Server Table
Designing a table can be a little complicated if you don’t have the correct knowledge of data types, relationships, and even column properties. In this tip, Brady Upton goes over the column properties and provides examples.
Two Steps Ahead
Today Steve Jones talks about those great DBAs, the Exceptional ones that do more than just respond to issues or set up monitoring on their systems.
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kantor Bank BCA KCP Lomanis Telp:08218154393
WA:08218154393 Jl. Gatot Subroto No.080A, RT.001, Cigobang, Gunungsimping, Kec. Cilacap Tengah, Kabupaten Cilacap, Jawa...
Alamat Kantor Bank BCA KCU CILACAP Telp:08218154393
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers