A Basic Introduction of Database, Tables and SQL.
It seems to be the most basic thing but this post is specifically to those who have just started or...
2015-10-29 (first published: 2015-10-20)
2,747 reads
Blog Posts
Columnstore Indexes – part 70 (“Filtered Indexes in Action”)
Continuation from the previous 69 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is the continuation from...
2015-10-29
850 reads
Columnstore Indexes – part 71 (“Change Data Capture, Change Tracking & Temporal”)
Continuation from the previous 70 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In the SQL Server world of data...
2015-10-29
908 reads
Default Sessions
The focus of this article will be to introduce the default sessions deployed with SQL Server. Some of these are internal and "private" while others are more "public" and...
2015-10-29
35 reads
Default Sessions
So I have blasted through a lot of technical articles about Extended Events. There is a lot of groundwork that...
2015-10-29
1,097 reads
Generating scripts for previous versions of SQL
I make a habit of using the latest version of SSMS even if I’m not working with the latest version...
2015-10-29 (first published: 2015-10-21)
1,669 reads
My PASS Summit 2015 Presentation
I’m going to present my session about working with parameters in PASS Summit on Thursday at 03:15pm. The title of...
2015-10-29
847 reads
PASS 2015 Session Report – KeyNote and SQL Server on Azure Virtual Machines: Features, Best Practices & Roadmap
So PASS officially kicked off this morning leading into the next 3 days of back to back sessions.
You could certainly...
2015-10-29
846 reads
PASS 2015 Session Report – KeyNote and SQL Server on Azure Virtual Machines: Features, Best Practices & Roadmap
So PASS officially kicked off this morning leading into the next 3 days of back to back sessions. You could certainly tell that the keynote was on… I mean...
2015-10-29
5 reads
PASS Summit 2015 Keynote – Day 2
Today is the second day of the SQL PASS Summit in Seattle, Washington. I’ll be live blogging today’s keynote address....
2015-10-29
941 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers