Security is a confusing topic to many, especially when it comes to understanding what rights are needed to monitor and use SQL Server Agent. This article will examine the rights and roles used for SQL Server Agent, as well as the security context requirements for jobs. More »
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS. More »
Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and your Instances that support In-Memory OLTP tables. More »
I had to do some performance testing for an upcoming MSSQLTips article and I thought I’d share the framework I... More »
Question of the Day
Today's Question (by Steve Jones):
In what editions of SQL Server 2014 are memory-optimized tables available?
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: SQL Server 2014.
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.
Pick up your copy of this great book from MVP Glenn Berry at Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
I have data for my salespeople in a table as follows:
Need to un-pivot some columns, pivot one column
- CREATE TABLE [dbo].[MyTable](
[CampusID] [int] NOT NULL,
[Campus] [varchar](20) NOT NULL,
[TermID] [int] NOT NULL,
[Term] [varchar](12) NOT NULL,
[StudentID] [int] NOT NULL,
[Qualification] [varchar](15) NOT...
Updating a table
- I am going to try and simplify this because I think I am thinking to hard for the problem at...
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.