Tag Archives: microsoft sql server
-
There EXISTS a place where SELECT 1/0 doesn’t return an error.
4September 7, 2017 by Kenneth Fisher
Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical …
Continue reading -
SQL Homework – September 2017 – Create a home lab
3September 5, 2017 by Kenneth Fisher
As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something …
Continue reading -
Create an empty table from a SELECT statement but without the IDENTITY.
3August 28, 2017 by Kenneth Fisher
A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like …
Continue reading -
Changing the version of an SSIS package.
23August 23, 2017 by Kenneth Fisher
Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say …
Continue reading -
Deploy an SSIS project to the SSIS catalog.
1August 21, 2017 by Kenneth Fisher
You’ve installed SSDT, created an SSIS project, created any packages you need and now you want to place that project …
Continue reading -
Creating an SSIS project
Leave a commentAugust 16, 2017 by Kenneth Fisher
Now that SSDT (SQL Server Data Tools) has been installed the next step is to create a project. First, open …
Continue reading -
Installing the (currently) latest Data Tools
5August 14, 2017 by Kenneth Fisher
I’m working on a project right now and it’s going to require me not only to refresh my SSIS skills …
Continue reading -
SQL Homework – August 2017 – Create a table
5August 2, 2017 by Kenneth Fisher
If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month …
Continue reading -
Performance is bad. Did you change anything recently? No. Are you sure?
5July 26, 2017 by Kenneth Fisher
Ever have this conversation? Dev: Hey, can you help me? The performance on my application is terrible all of a …
Continue reading -
Default SQL Agent Reports – Top Jobs
3July 24, 2017 by Kenneth Fisher
Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several …
Continue reading
SQL Studies 