 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | SnowCrash for SQL Server Years ago I read Snow Crash and really enjoyed the novel. In it, a virtual reality world exists, where many people connect to and roam about in a virtual world, experiencing various 3D type views of applications, systems, and data. There are numerous other novels that enjoy similar worlds, like Ready Player One and Warstrider. It's an idea that many people look forward to as virtual reality systems grow in power and capability. With Microsoft's HoloLens, there's a project underway to bring more virtual reality to our everyday world, including the management of IT systems. There are various people at Microsoft Research looking to allow us to navigate the complexity of our IT installations, including SQL Server instances, to better understand the relationships between our servers. This is exciting in some sense. Can you imagine being able to "move" through space to a Production SQL Server, viewing the real time access of queries, users, and data. We would be able to grab a query and pause it, cancel it, even follow chains of blocking to find the sources of issues in a way that is likely to be more natural for many of the people that will enter the technology field in the next 20 years. It's April 1, and I'm somewhat joking and somewhat not. I'm not sure if there is any project underway specifically for managing IT systems, but I could see this as a way of better visualizing and working with large amounts of data. Certainly there might be visual analysis of Big Data that makes sense, but I could see large amount of security data, logging, auditing data that is better dealt with in some sort of virtual reality interface. I know this might seem strange to some of us. I've tried the Oculus hardware and Samsung VR systems, and they have a long way to go before I'd want one, but I have dreams of being able to more easily navigate the complexity of our systems in a way that might feel more natural and intuitive than the ever growing list of folders and dialogs in Management Studio. 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 ( 2.8MB) 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 |  | | Library of articles for Database Lifecycle Management Discover a collection of articles covering important checkpoints on the journey of database lifecycle management - including team processes, version control and release management. Find out more on Simple-Talk. |
|  | | SQL Toolbelt – everything you need to work with SQL Server Redgate’s SQL Toolbelt contains the industry-standard tools you need to make you and your team more productive, to protect your data and manage performance, and to include your database in agile processes. Find out more and download your free trial. |
|  | | Discover 52 tips to improve your .NET performance Our new eBook features dozens of tips and tricks to boost .NET performance. With contributions from .NET experts around the world, you’ll have a faster app in no time. Download your free copy. |
|
|
|
| | |  | Steve Jones from SQLServerCentral.com In an Azure SQL Database, you pay for a certain number of DTUs, but what are these? Steve Jones explains. More » |
 | Additional Articles from SimpleTalk With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the data-document model's hierarchical nature causing a fundamental conflict with relational theory? We asked our relational expert, Hugh Bin-Haad to expound a difficult area for database theorists. More » |
 | Andy Warren from SQLServerCentral.com It’s still a bit hard to believe that SQL Server will soon run on Linux. If you think back to the early days of SQL 7, 2000, even 2005, who would have bet any money on it ever happening? More » |
|
|
| | | Today's Question (by Steve Jones): What was the code name for the In-Memory OLTP table technology that was built into SQL Server 2014? Hint: This is Greek for hundredfold. |
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. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| | Yesterday's Question of the Day |
| Yesterday's Question (by Peter McLean): Running the SQL below will give which results? DECLARE @Table TABLE (ID INT PRIMARY KEY) INSERT INTO @Table (Id) VALUES(0), (2), (1) DECLARE @SelectVariable INT = 1 SELECT@SelectVariable = ID FROM@Table SELECT@SelectVariable SELECT@SelectVariable = ID FROM@Table WHEREID = 3 SELECT@SelectVariable
Answer: 2,2 Explanation: If the SELECT statement returns more than one value, the variable is assigned the last value that is returned. If the SELECT statement returns no rows, the variable retains its present value. Ref: MSDN - https://msdn.microsoft.com/en-us/library/ms187330.aspx It is recommended that you use SET @local_variable instead of SELECT @local_variable
» Discuss this question and answer on the forums |
|
|
| | | Steve Jones from SQLServerCentral.com This is a quick script I use to quickly build a tally table. If you need more numbers, you can add more joins to the Tally CTE. 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.
Restore help needed for 1.5 TB database. - All, I need to restore the DB which is close to 1.5 TB from Prod to QA. It has close... Confused about Alwayson Availablity group - Hi all, I am trying to understand the alwayson availability group and how it works. I find it particularly confusing when it... Understanding Implicit_Transaction on - INSERT block SELECT - why? - Hi all, I am not sure if this is normal, i tried googling but have never found a similar thread in...
Using Subqueries as Calculated Fields - I have a concept question on this code: [code]SELECT cust_name, cust_state, (SELECT Count(*) FROM orders WHERE order.cust_id=customers.cust_id) as orders FROM customers ORDER BY cust_name;[/code] I... Nested Joins - Having syntax and bounding issues - Hello. My first post here and hope to get some help. It'll be obvious that I'm a newbie. I apologize for...
Elementary ? regarding distinct select query - Hello all, I need some help with a query that adds numbers into a table queue. Problem now is that it... Moving a SSRS report and datasource from 2008r2 to 2012 - I am attempting to move 1 report and 1 datasource from a 2008r2 server to 2012 server using rsscripter. I got...
Convert a string with an array of variables? - Does anyone have a better solution for this? I would think I have to be overlooking something. I need to convert...
About index - What is the reason. - Hi all, Can any one tell me the reason why unique clustered index created by default when we create primary key. What... which algorithm is used in my query? - i am using this query to find out duplicates in my table. Please tell me what kind of algorithm is... By date - I would like to run for 100 days of data. getdate() - 6 april 7april - 14 april and so on.. How can I break into... Processing strings. - Hello Processing strings. Examples are replace, DelimitedSplit8K. And lots more. What is a good way to process the string, but not process the...
ROW_NUMBER() OVER (PARTITION BY *** ORDER BY ***) excluding NULL values - Does anyone have an idea how to tweak the TSQL above to exclude assigning a row_number to rows for a...
Complicated performance issue - Hi All, We have 2 live environments both with same database structure and application but there is a big difference in...
SSRS Restart necessary to resume performance - Hopefully someone here can give me some theories on whats up with some ssrs instability ive faced lately... This has...
SSRS Report on Local Server works fine but not through Remote server - Hi, I deployed a SSRS (2005) report on my Report Server and is working fine, but when tried through Remote Server...
Poweshell script to script out jobs, databases, users, linked servers, logins, roles, alerts, etc from a list of servers - create a c:\servers.txt file with list of servers and copy the following into a file .ps1 enjoy function getwmiinfo ($svr) { gwmi -query "select...
Downloading files from MVS(Mainframe) to local folder using FTP Task(SSIS) - Hi, I want to download the files from MVS system to my local folder using FTPTask of SSIS. When I am...
Alter Database with variable - Hello together, I want to use a variable in an ALTER DATABASE command. Example: [i]DECLARE @db varchar(32) set @db = 'Test' Alter Database @db Set Recovery...
MS SQL vs Oracle - HI All, Recently i was thinking about Oracle, beacuse right now I'm MS SQL DBA/DEVELOPER. Some people said that oracle is... |
|
| 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 |
|
|
