 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | Your Technology Budget After I wrote about a home lab recently, someone was curious about the amount of money that others invest in their technology lab, habit, or hobby. I thought that was fairly interesting, so I decided to ask others to get an idea of what amounts people spend and even on what. How much do you spend on technology in a year? Let's skip cell phone and Internet service bills, but if you buy cell phones, tablets, computers, Kindles, or other gadgets, let us know. I'd be curious about your spending on your career, which might be travel and events, training, books, etc. versus the spending on technology for fun. For me the amounts vary dramatically. The vast majority of my spending on technology is for replacement pieces and parts. I will buy hard drives or monitors or memory, but rarely anything more fun in most years. I don't spend too much on learning as I get a Pluralsight subscription, and of course, I read SQLServerCentral. I rarely take training, but my generous employer usually covers that. In fact, most years, my total expense for technology is likely a few hundred dollars at the outside. I have purchased a few Kindle devices for reading, and I've gotten cases and batteries for my cell phones. I do go through keyboards and mice every year or two, sot hose are expenses, but rarely anything more interesting. I did buy a Pebble watch a few years ago. This year was an exception as I spent a bit to rebuild a desktop that has been aging. I didn't get everything I wanted, but I substantially improved the speed, which was the important thing. I'll also likely add in a new tablet next year to replace my aging iPad Mini (non Retina) to help with coaching volleyball. I'd like a drone for some fun camera work with kids and sports, but I suspect that is not likely to happen in the next year. Those gadgets are expensive for a complete indulgence. Let us know this week what you're spending money on in technology and if any of those items have proven themselves really valuable, or just lots of fun. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 4.2MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | Could you deploy a high number of databases? Imagine working in a 70-strong IT team, with 91 applications and multiple complex databases. Now imagine deployment time. It's not fiction, it's fact. See how financial services company, FlexiGroup, has brought speed and precision to database deployments. Read their story. |
|  | | Find SQL in your database for free For example, want to rename one of your table columns but are not sure what stored procedures reference it? Using Redgate’s free SSMS add-in, SQL Search, you can search for the column name and find all the stored procedures that use it. Find out more and download now. |
|  | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more. |
|
|
|
| | |  | Joshua Healy from SQLServerCentral.com Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+ More » |
| | Additional Articles from SQLPerformance.com Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers. More » |
 | Steve Jones from SQLServerCentral Blogs SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself... More » |
| | meaganl from SQLServerCentral Blogs A client wanted to upgrade their SSAS model to SSAS 2016 to take advantage of some of the features of... More » |
|
|
| | | Today's Question (by Henrico Bekker): Which algorithm and return type does COMPRESS() return in SQL 2016 |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: COMPRESS(). We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): You work with a junion DBA that was told to implement a way to track who is logging into a SQL Server 2016 instance. The DBA wants to use a logon trigger, but you have been concerned with the way this trigger is written. As part of a troubleshooting script, you want to ensure you can quickly remove the logon trigger if there are issues. The trigger name is "CaptureLogins". Which batch should you run?
Answer: DROP TRIGGER IF EXISTS CaptureLogins; GO Explanation: The new syntax in SQL Server 2016 allows you to drop an object if it exists. This is known as DROP IF EXISTS, but this is not the syntax. The correct syntax is the DROP <object> syntax with IF EXISTS added. In this case, DROP TRIGGER IF EXISTS is the correct syntax. Ref: DROP TRIGGER - https://msdn.microsoft.com/en-us/library/ms173497.aspx
» Discuss this question and answer on the forums |
|
|
| | | Vimal Lohani from SQLServerCentral.com to access the image sql server account should have permission to the folder. Please write the image path on openrowset. also give folder path if you want to retrieve it from sql server. More »
|
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
Help with SQL 2012 to SQL 2016 P2V considerations - Hello experts, I'm planning an upgrade from SQL 2012 Enterprise Edition to SQL 2016 Enterprise Edition that also includes a physical-to-virtual...
Accidentally Overwrote Stored Procedure - I was working in the "Modify" script of a stored procedure just now. I accidentally selected only a small part...
Restarting SQL Server Instance from SSMS Error - Just installed a new SQL Server 2014 instance. When I try to restart the sql server instance in SSMS by... Displaying Multiple rows clock event Under a different Column view - I would like to query the data were table output is by each row but i need need display the...
How do you work with multiple developers on same DB - Hi All Our dev team is growing. We use red-gate toolbox, so we have schema compare, data compare and source control....
SQL query running slow after upgrading from 2005 to SQL 2012 - I’m seeing some strange behaviour with the ''update" query If you increase the ‘available’ memory available to the SQL Instance... Recording data changes - I'm working with a windows application that uses SQL Server 2012 on windows server 2012 R2. There is something happening... sql backup - Do you have any idea how long it might take to sql backup for 600 gb. Thank you HELP! I've got to give a talk to our local .NET geek meet on SQL server - Hi guys, I have agreed (foolishly) to give a 30-minute presentation to our local .NET developers meeting on entitled "Why your...
Dynamic rows into columns - Hello, I'm a SQL Server novice. I've been polishing up on my T-SQL skills while working for the last few months...
Extremely slow initial connection using ssms - For the last week or so anytime I load ssms to connect to my sql server, the initial connect takes... Shrink database while restoring - Can we shrink the database files while restoring from backup?
One to many in a t-sql statement - I'm trying to work out the best way to create this view. The best way to think of it is to...
Can I allow a user to select nothing a multi-valued parm? - We have a report where a user can search for persons. One of the parameters allows the user to select which...
Parameter on Powershell Script - I'm having some problems sending parameters to a Powershell script when it includes a dash (-) in it. Here's an example...
Fact table with hundred of columns - Any alternative? - Hi everyone, I am designing a accumulating snapshot fact table to evaluate the performance of the product forecasts since they...
What is the right way to design a data flow between development and production dbs? - Hi, Firstly I hope this question is in the right forum. I usually ask pretty standard TSQL questions, and this is...
I need help with a query - I have a table a,b,c and I need to show a if is >=0 and b >0 and c > 0...
Dynamic Ordinal Position with SQL XML? - Hey all! I have a SQL XML GURU question. I have an XML that I essentially need to walk to get...
ref integrity after Migrating database to sql server 2008 R2 - The unpleasant task of upgrading an MS Access 10 database to SQL Server 2008 R2 fell on my shoulders. The Access... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
