Recently, I wanted to bring data into a SQL Server table, and I wanted to do so w/o SSIS. I know that I had done this before, but, of course, I had forgotten the details. I found the best answer…
Category: SQL 2008
Querying a remote server w/ SQLCMD
So, sometimes you need a simple way to run (often the same) command on two different servers at the same time. Perhaps setting up a Linkserver is difficult, or simply too time consuming. Here’s an option. Try SQLCMD.
SSRS Data Source Lister
Hello, Sometimes, you’re in the middle of doing something, and you need an answer. You google it and find such a great solution, you want to keep it handy for … whenever! Here is such a post. As the title…
SSAS not logging?
So you’ve followed all the advice and set up logging so that you can know who is using your cubes. Things are good. One day you wake up and see that your logs no longer are logging. You open your cube…
Who’s been using your Cube?
To keep track of how many people are actually using the results of your hard work… You have two considerations: 1. Turn on Logging on your Analysis Services Cube 2. Actually query that log…
List out all the database users and the roles they are members of…
Needing to figure out which users in which database are members of roles? You’ve come to the right spot! Try this code…
Script version of SSMS “Sql Server Agent” Job Activity Monitor
Are you tired of “right-click” “refresh” on the job monitor? Want a single, simple script to tell you what step a job is at? Try this script:
Sql Binaries location, SessionTimeout, Sql Version
OK…this is a ‘strange’ post… That is because the script i have for you today is a real ‘utility’ script… it does three things that occasionally come in REAL handy! It tells you the location of your SQL binaries. It…
Sql Server Status
What’s the first thing you do when you get a report of a problem on one of your servers? In my case… i run this following script that gives me a quick overview of all the top counters of interest.
Backup Script to replace xp_sqlmaint
Need a backup script because xp_sqlMaint is not running on 2008? Try this one. You need only fill in the database name and directory name in the appropriate places below: