At SQLServerCentral and Simple Talk, with the sponsorship of Red Gate Software, we decided to create some end of year awards in various categories, based on the community, not companies or products. We kick off our nominations today in a number of categories, including Advice that saved my bacon in 2013, Best Speaker, Best Outfit, and more. You can read more about the categories in today's announcement.
The idea is that the community can recognize others in the community with a nomination, and some supporting material that encourages others to nominate the same individual, and vote for the winner. The top five with the most nominations will get voted on over the holidays with awards presented in January.
I hope you have fun with this, and think back to those people and events that stand out in your mind in 2013. Nominate them, give a few reasons, and celebrate the help that each of us gives each other as a part of the SQL Server tribe.
PS: we had a great #sqlski last year for SQL Saturday in Albuquerque and we're doing it again this year. Feel free to join us at Taos on Friday, January 24th, right before SQL Saturday #271 in Albuquerque on Jan 25, 2014.
Rapidly documenting your entire database schema just became even easier with SQL Doc 3. Includes a new UI, documentation of database- and server-level properties, and greater customization control. Download a free trial now.
Try new SQL Monitor Hosted
Get real-time server performance updates and instant access to the data you need to fix the problem, whilst we take care of the monitoring software. Get started now.
Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…
SQL Server 2012 introduces a new feature to issues backups on the Windows Azure Blob Storage service directly and restore from there when needed. But how does it work and how to get started using T-SQL commands for backup and restore operation? More »
SQLServerCentral and Simple-Talk are co-hosting the Tribal Awards. Nominations open today for each of the 11 categories which recognize technical excellence, willingness to help the wider community, and exceptional SQL Karaoke skills. More »
SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
In SQL Server 2014, the technology code named "Hekaton" refers to what?
Answer: Memory-Optimized Tables
Hekaton is the code name for the technology behind memory-optimized tables in SQL Server 2014.
We are using sp_help_revlogin to make login script, but it doesn't enable the login which has sysadmin role. It is very common problem during server migration. We use the this technique to solve the issue.
Workaround: How you can enable the sysadmin role correctly for all the login which has sysadmin role.
This script creates the command in old server which need to execute to the new server.
I am creating a simple database to log the number of visits from clients. The table is as follows :
Convert SQL Views to SQLite
- What i want to do is migrate my SQL Views to SQLite.
I have tried the following tools:
But those tools seem...
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.