This week I set up a a user in our SQL Server. To save time, I simply assigned all of the permission that user needed. Then I remembered how many times I have been burned by this shortcut. It is so much easier in the long run to create a role in SQL Server, assign […]
SQL Permission Roles versus User Read More »
I am a relative newbie with SSAS Tabular. I needed to find the Row Level Security rules for a role in our SSAS instance. I have experimented with Row Level Security using Visual Studio, but Visual Studio is not set up yet in our environment. However, I learned it is quite easy to find this
Reading SSAS Tabular Row Level Security in SSMS Read More »
When using dynamic SQL there is always the possibility that someone will inject SQL that does harm. They can put queries that can drop objects or can create sysadmin logins. Running the scripts as low permission users can reduce the potential harm. But that takes time to research and is easy to cut. You can
Limiting permissions with “Execute as” when using dynamic SQL Read More »
I had an ETL project to copydata from one SQL Server to another. The conversion rules, the data constraints and other metadata were in an Excel spreadsheet. Many of the cells consisted of multiple rows of data. But how to extract the rows? I was able to shred these cells into SQL rows by using
Shredding multiline column using xml Read More »
There has been a basic method from SSIS 2005 for creating an SSIS package template. You create package, then put that package into a magical folder (under the Common7 folder of the appropriate version of Visual Studio), and voila you have a package template (see http://www.mssqltips.com/sqlservertip/2841/creating-ssis-package-templates-for-reusability for the full process). A major problem with this process has been
SSIS Template, changing GUIDs Read More »