In our free SDU Tools for developers and DBAs, we’ve added a lot of scripting tools. The tool that I’m describing today is one of the most sophisticated tools in our scripting options. It’s ScriptTable.
It’s very flexible. For example, it can change the name of the table, or the schema that it’s in. It can force ANSI_NULLS and ANSI_PADDING on or off. It can change user-defined data types to their base types, change compression strategies, and more.
2019-01-30
In the first blog post of this introductory series for learning T-SQL, I talked about what SQL is. That then raises the obvious question, about what T-SQL is.
Well the promise of SQL was that we’d have one language, and it would work with all databases. Did that end up working? Well, sort of.
Committees, even the ANSI committees, are notoriously hard to make progress in. Everyone has no doubt heard the joke about a camel being a horse designed by a committee.
2019-01-28
I love working with SQL Server spatial. Don’t just use boring tables and charts. Spatial data can really help to bring your reports and analytics to life. Don’t assume spatial is just about maps. (It’s not). Don’t assume you don’t have spatial data. (I’m sure you have addresses, locations, etc.)
We’ve been working hard lately on getting many of our popular in-person courses, converted to being available online and on-demand. We’re really proud to now have SQL Server Spatial for Developers and DBAs available.
2019-01-25
In a previous post, I showed how you might use split windows to allow you to work on different parts of a single query at the same time.
But what if you need to work on two queries and see parts of both of them?
That’s where tab groups can help you. You can create both vertical and horizontal groups. For me, the most useful is typically side-by-side vertically, for when I’m comparing two sections of code.
2019-01-24
In our free SDU Tools for developers and DBAs, we’ve added a lot of scripting tools. To script out SQL authenticated logins (as opposed to Windows logins), we have ScriptSQLLogins.
You can see how to use it in the main image above. It’s a function, that takes a list of the logins to script. You can pass the value ALL or a comma-delimited list.
Importantly, as well as the login and the hashed password, it also scripts other details:
2019-01-23
In the 1990’s I was running a software company. We had a great sales guy who was also a great friend. One of the things that I loved about working with him, is that even if he didn’t know how to solve a technical problem, he’d ask the questions that I led me to see a problem differently. I could then solve it. I wish every technical person was lucky enough to have someone like that.
2019-01-22
For some time, I’ve been thinking that I should create a series of blog posts about the T-SQL language, from a beginner’s perspective. For the next few months, my Monday posts will be intro-level T-SQL.
The obvious topic to start with then, is what is SQL in the first place?
When I started working with databases in the 1980’s, there were many, many different types of database. Each database had its own language that was used to get information back out of the database, or to put the information into the database in the first place.
2019-01-21
I spend a lot of time on client sites and time and again, one of the mistakes that I see people making, is trying to start with large projects. I think one of my all time favorite quotes about IT is:
Any successful large IT system used to be a successful small IT system.
The next time you’re thinking about creating a project that’s going to have a big bang outcome, please remember this. The history of the industry is that it really is likely to be a big bang, and not in terms of being a big success like you’d hoped for.
2019-01-18
If you are working with really long script files in SQL Server Management Studio (SSMS), you might need to work on more than one part of the script at the same time. Perhaps you need to work on a function, and also on the code that calls the function.
On the Window menu, there is a Split option.
When you first do this, you’ll see a split window with the same query at top and bottom:
2019-01-17
In our free SDU Tools for developers and DBAs, there’s another useful scripting tool. It scripts out the logins that are members of server roles. It’s called ScriptServerRoleMembers.
One key advantage of having these scripting procedures and functions is that you incorporate them into other applications, and programmatically perform the scripting if you need to.
But if you just want to create a script, that works too.
By default, it lists permissions for all logins, but you can also provide a list of the logins that you’re interested in, as a comma-delimited list, to the @LoginsToScript parameter.
2019-01-16
