How to run SQL Profiler Trace at night, at a specific time?

 3r3182. 3r3-31. How to start the SQL profiler trace when the problem needs to be caught from 3:00 to 3:30 in the morning? This can be done using server-side tracing, but this is extremely inconvenient. It is not difficult, but uncomfortable, and always lazy. Finally, I decided to automate this once and for all. Like this:
 3r3182.
 3r3182. How to run SQL Profiler Trace at night, at a specific time?  3r3182.
 3r3182. Jenkins here, by the way, is completely optional and serves only as an interface to invoke the script with the necessary parameters:
 3r3182.
 3r3182.  3r3182.
 3r3182...
+ 0 -

Search for a damaged object by the number of the damaged page in MS SQL Server 2005

Search for a damaged object by the number of the damaged page in MS SQL Server 2005 3r3r1616. 3r3-31. The other day, one of the MS SQL Server databases went to Suspect, there was an error message in the log: 3r3151.  3r3r1616. 3r33939. Msg 710? Level 2? State ? Line 14
 3r3r1616. Database ID ? page (1: 386499), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can be read uncommitted data on a data page. Run DBCC CHECKTABLE. 3r33939. 3r3151.  3r3r1616. The base was transferred to Emergency and attempted to perform DBCC CHECKDB, but execution stopped immediately: 3r3151.  3r3r1616. 3r33939. Msg 892? Level 1? State ? Line 13
 3r3r1616. Check ...
+ 0 -

Create an arbitrary order of elements in the list of dimensions and measures of the Excel pivot table for the table model of the SSAS cube

Create an arbitrary order of elements in the list of dimensions and measures of the Excel pivot table for the table model of the SSAS cube 3r3163. 3r3-31. If you had to deal with a cube in which the number of measures and dimensions over9000 and three screens are not enough to fit it, then you probably also heard users moaning about the inconvenience of working with this monster. After all, users often work with the same measurements, without which almost no sample can do. However, due to the peculiarity of the Excel, who loves to sort alphabetically, all the elements that are in the 3r3134 area. Fields of the pivot table [/b] These most popular objects are often scattered around the list, mixed with the rest (rarely used) elements...
+ 0 -

How easy it is to take and view .NET assemblies in SQL Server using ICSharpCode.Decompiler

You can of course take third-party utilities, such as some kind of open-source ILSpy, save the assembly to disk and then decompile.
 
 
3r3333. How easy it is to take and view .NET assemblies in SQL Server using ICSharpCode.Decompiler
 
But you just want to connect to the database and see all the assemblies and what's inside.
 
 
And besides, there are a lot of high-quality Opensource components for all cases of programmer life, and writing in C # is convenient and easy :)
 
 
So /
 
Nuget package
 
 
3r3333. 3r3334.
 

We read from the base all assemblies


 
SqlDataReader, SQL query trivial: 3r-3248.  
 
3r33232. SELECT
af.name,
af.content
FROM sys.assemblies ...[/h]
+ 0 -

This post is with reports and video on MS SQL Server

In June we conducted a MIT on Microsoft SQL Server - speakers from Yandex.Money, Kaspersky Lab, AwaraIT and SpbDev shared their experience with colleagues. And now upload the video to the public.
 
Under each video - timecodes of key places, but we advise you to watch, listen and listen whole.
 
Data-driven subscriptions in SSRS
 

for activities , learn SQL and subscribe to our habablog.
Only registered users can participate in the survey. Enter , you are welcome.
World Championship in DBMS. What are the best?
MongoDB
SQLite
Firebird
MS ...
+ 0 -

Version control inside SQL Server'a

Version control inside SQL Server'a Julia : So, who changed my procedure yesterday?
 
Lyosha : not I
 
Maxim : not I
 
- Guys, can Git get?
 
Серёжа : It is high time!
 
2 weeks have passed
 
 
Julia : Rebyyayat?
 
- Yul, and you did not commit?
 
Julia : damn no ( .
 
 
That's how it all began. Well and what, each character and each line to commit?
 
And maybe all this will happen by itself?) At this moment
begin to come to mind.  
DDL triggers ...
+ 0 -

RabbitMQ - SQL Server

RabbitMQ - SQL ServerA week or two ago I saw message on the forum RabbitMQ Users , on how to send messages from SQL Server to RabbitMQ. As we work closely with this in Derivco , I left some suggestions there, and also said that I write in a blog about how it can be done. Part of my message was not quite true - at least until this moment (sorry, Bro, was very busy).
 
 
Awesome thing, this is your SQL Server . With its help, it is very easy to put information into the database. Getting data from the database using a query is just as easy. But getting the newly updated or pasted data is ...
+ 0 -

Unit testing of database scripts

Unit testing of database scriptsTaking the convenience of using a unit of tests on my favorite C ++, I tried to transfer my experience to TSQL, especially since the new employer likes a useful initiative on the ground and distributes buns for it.
 
 
I looked several known frameworks I came to the conclusion that, as a rule, they are cumbersome and bring additional syntax, which must be studied additionally.
 
 
Some frameworks work beautifully and please the eyes of the manager who is shown to them, but they have a number of limitations that I did not like.
 
 
I also wanted to implement everything on a pure kosher-halal-orthodox ...
+ 0 -

ThinkingHome.Migrator - version migration of the database schema on the. NET Core

ThinkingHome.Migrator - version migration of the database schema on the. NET Coreplatform.Hello! Today I released a new version of ThinkingHome.Migrator - a tool for the versioned migration of the database schema to the .NET Core platform.  Packages are published in NuGet , written detailed documentation . You can already use a new migrator, and I'll tell you how it came about, why it has version number ??? (although this is the first release) and why it is needed when there is EF Migrations and FluentMigrator . Migrator.NET . The migrant proposed a new idea for that time - to set changes to the database as migrations. Each migration contains a small ...
+ 0 -

Go through NULL

Many people know and use the built-in function ISNULL (X, Y), which replaces the first argument with the second argument if it is (first) NULL. Less useful is the inverse built-in function NULLIF (X, Y), which returns NULL if the first argument is equal to the second argument. The combination of these two functions avoids the use of IF-ELSE or CASE-WHEN constructions, which makes the code more compact. If it's interesting to see a couple of examples - welcome to the cat.
 
 
 
For example, here is the code that outputs 10 random integers in the range from 1 to 3? and the nearest value to the output ...
+ 0 -